SSJ wrote:
Hello to all!

I want to start an inventory cycle count program in my company. How can
Excel be used to do random selection? The only data I currently have is
a listing with the following headings:

1) Part Code
2) Part Description
3) Location Code
4) Quantity on hand
5) Unit Cost
6) Total Cost
7) Cateogry

The accounting software does not provide, currently, a usage report that
I use to apply ABC method of selection items.

Any suggestions from Excel using inventory gurus would appreciated.

Thanks
SJ

not sure about how to randomize your choices but why would you want to?
We do cycle counts here and typically do certain sections at a time as
opposed to selecting random items. This way we know that over a months
time we count every item in every section.

gls858