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?

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?

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?