Stock monitoring work sheet.

[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 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 !

[Philip Reece-Heal]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=29714
> View this thread: http://www.excelforum.com/showthread...hreadid=494280
>

[momo0379]

Thanks Philip, that was useful. Have another query....

I have an IF function in one cell. Is it possible to write that value to another cell (a reporter cell) so that once that:

1) the IF funcition has become True the reporter cell show that value

2) If the IF function were then to become false the reporter cell does not change

Basically like a one way valve. COUNTIF works but if I press delete in the data entry box [see first message] all the counts reset. Anyone have any ideas?