software

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 a
large number of stock items listed by name in one column. What I'd like
to do is a have a single cell at the top where I enter the name of an
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 the
top and the next name entered, and so on. Is this possible? Am I going
to have to stray into the world of macros? Please help as my brain is
melting !--
momo0379
------------------------------------------------------------------------
momo0379's Profile: www.excelforum.com/member.php...oamp;userid=29714
View this thread: www.excelforum.com/showthread...hreadid=494280If 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
Philipquot;momo0379quot; gt; wrote in
message ...
gt;
gt; Bit stuck here wondered if anyone can help? Is this possible?
gt;
gt; I'm trying to create a sheet to record the movement of stock. I have a
gt; large number of stock items listed by name in one column. What I'd like
gt; to do is a have a single cell at the top where I enter the name of an
gt; item and a commulative count will appear next to that item on the list.
gt; After entering the name it can be deleted from the single cell at the
gt; top and the next name entered, and so on. Is this possible? Am I going
gt; to have to stray into the world of macros? Please help as my brain is
gt; melting !
gt;
gt;
gt; --
gt; momo0379
gt; ------------------------------------------------------------------------
gt; momo0379's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29714
gt; View this thread: www.excelforum.com/showthread...hreadid=494280
gt;

Thanks Philip, that was useful. --
momo0379
------------------------------------------------------------------------
momo0379's Profile: www.excelforum.com/member.php...oamp;userid=29714
View this thread: www.excelforum.com/showthread...hreadid=494280