Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

Stock monitoring work sheet.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
momo0379 - 17 Dec 2005 01:37 GMT
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
large number of stock items listed by name in one column. What I'd lik
to do is a have a single cell at the top where I enter the name of a
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 th
top  and the next name entered, and so on. Is this possible? Am I goin
to have to stray into the world of macros? Please help as my brain i
melting :eek:
Philip Reece-Heal - 17 Dec 2005 07:36 GMT
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

> Bit stuck here wondered if anyone can help? Is this possible?
>
[quoted text clipped - 6 lines]
> to have to stray into the world of macros? Please help as my brain is
> melting :eek: !
momo0379 - 18 Dec 2005 10:12 GMT
Thanks Philip, that was useful. :
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.