Use Excel to randomly generate selections for cyle counting?
 

Hi - I need to perform cycle counts on approximately 5,000 items. Each item
needs to be counted at least once a year. Does anyone know if and how Excel
can be used to randomly select products for counting based on the last date
of activity?

Use Excel to randomly generate selections for cyle counting?
 

have a look at =RANDBETWEEN(1,5000) (you need to load Tools Add-ins the
Analysis toolpack).
This will get you a random number from 1 to 5000. Refresh it with F9.

Does that help get you started?

--
Allllen


"Brad Dean" wrote:

Hi - I need to perform cycle counts on approximately 5,000 items. Each item
needs to be counted at least once a year. Does anyone know if and how Excel
can be used to randomly select products for counting based on the last date
of activity?

Use Excel to randomly generate selections for cyle counting?
 

Hi Allllen! Thanks for your response. I should have been clearer. Rather
than generating a random number, I would like Excel to randomly select an
existing item number to be counted.

Here is a specfic example of what I am looking for:

We have categories of inventory (A B C items) Each A item needs to be
counted four times a year; each B item 3 times, each C item 2/yr. Every time
we count an item, we enter the date is was counted. Based on the number of
hits per item category per year, I would like Excel to select another part
number to count.

Again, I appreciate your time and sorry for the wild goose chase!

"Allllen" wrote:

have a look at =RANDBETWEEN(1,5000) (you need to load Tools Add-ins the
Analysis toolpack).
This will get you a random number from 1 to 5000. Refresh it with F9.

Does that help get you started?

--
Allllen


"Brad Dean" wrote:

Hi - I need to perform cycle counts on approximately 5,000 items. Each item
needs to be counted at least once a year. Does anyone know if and how Excel
can be used to randomly select products for counting based on the last date
of activity?