[jukofyork]

[ QUOTE ]
It would probably be easier to pull them from the database directly - or you could use some of that WSH scripting to pick random cells from Excel.

There must be a way to do it from excel itself, probably with VBA - I don't know enough to tell you how to do it in that way.

Maybe xpost in CTH? - there are lurking excel gurus in there on occasion [img]/images/graemlins/smile.gif[/img]

[/ QUOTE ]
Create a new column of random numbers and sort using them, then pick however many you want from the top of the randomly sorted list.

To create the random column, just use "=Rand()" which will create reals in the range {0..1}, then double click the "magic" excel duplication thingy (not sure what it's called...).

Juk [img]/images/graemlins/smile.gif[/img]