Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cycle count with Excel
I have 3 tables of imported info including part number and on hand qty. Each
list has the following classifications: A) should be counted once per month B) should be counted once per quarter C) should be counted once per year. I would like to have a formula with those parameters built in so I can run a query weekly to pull what list of parts need to be counted to conform to the above mentioned classifications. If there is a way to keep a running count of what was previously counted, that would be a bonus. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a cycle count report | Excel Worksheet Functions | |||
excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
INVENTORY CYCLE COUNT IN EXCEL | New Users to Excel | |||
2 cycle logarithmic? | Charts and Charting in Excel | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) |