| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stock monitoring work sheet.
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stock monitoring work sheet.
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stock monitoring work sheet.
Thanks Philip, that was useful. :) -- momo0379 ------------------------------------------------------------------------ momo0379's Profile: http://www.excelforum.com/member.php...o&userid=29714 View this thread: http://www.excelforum.com/showthread...hreadid=494280 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make invoice take items off stocklist in excel workbook | Excel Worksheet Functions | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Do you have a work in progress sheet | Charts and Charting in Excel | |||
Linear Mode
