Stock monitoring work sheet.

  • Thread starter Thread starter momo0379
  • Start date Start date
M

momo0379

Bit stuck here wondered if anyone can help? Is this possible?

I'm trying to create a sheet to record the movement of stock. I have
large number of stock items listed by name in one column. What I'd lik
to do is a have a single cell at the top where I enter the name of a
item and a commulative count will appear next to that item on the list
After entering the name it can be deleted from the single cell at th
top and the next name entered, and so on. Is this possible? Am I goin
to have to stray into the world of macros? Please help as my brain i
melting :eek:
 
If your stock items are in column A from row 2 down, and you use A1 to enter
the name of an item you want to count, then in B2 type the formula
=COUNTIF(A2:A65536,A1) and that will give you the result

Hope that helps
Philip
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stock control question 4
formula for current stock count needed 2
Conditional Formatting Issues 1
Pivot - top 10 stocks & missing info 2
how to put qty & date of the item 0
current stock formula help? 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Adding up total hours worked on employee schedule using various criteria 0

Back
Top