random numbers

[jiminic]

I have a column that has roughly 2000 entries in it. Each entry is made up of 3 letters and 9 numbers. Is there a peice of code that I could use that will allow me to randomly select 15 -20 of these enties and return them to a different section of the page?

Thank you.

[Paul]

If your entries are in column A, for example, you could use this in b1:b15:

=INDIRECT("a"&RANDBETWEEN(1,2000))

Because this uses 'RANDBETWEEN', if anything on your sheet triggers a recalculation b1:b15 will change, so you may want to copy and pastespecial>values after these formulas randomly generate their values. (Of course, when you do the paste, it will paste the values you copied, but those formulas in B1:B15 will recalculate again.)