Re: Stock monitoring work sheet.

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


"momo0379" <momo0379.205v0p_1134783603.1134@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:momo0379.205v0p_1134783603.1134@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Bit stuck here wondered if anyone can help? Is this possible?
>
> I'm trying to create a *** 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 :eek: !
>
>
> --
> momo0379
> ------------------------------------------------------------------------
> momo0379's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=29714
> View this thread: http://www.excelforum.com/showthread.php?threadid=494280
>


.

Quantcast