Re: Stock monitoring work sheet.
- From: "Philip Reece-Heal" <philip.reece-heal@xxxxxxxxxxxxx>
- Date: Sat, 17 Dec 2005 07:36:30 -0000
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 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 :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
>
.
- Follow-Ups:
- Re: Stock monitoring work sheet.
- From: momo0379
- Re: Stock monitoring work sheet.
- References:
- Stock monitoring work sheet.
- From: momo0379
- Stock monitoring work sheet.
- Prev by Date: Re: ? Link attached - How to validate SIN (Social Insurance Number)
- Next by Date: Re: Complicated Vlookup/count problem
- Previous by thread: Stock monitoring work sheet.
- Next by thread: Re: Stock monitoring work sheet.
- Index(es):
Relevant Pages
|
