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?