ExcelBanter - Data Analysis

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Analysis (https://www.excelbanter.com/excel-discussion-misc-queries/77850-data-analysis.html)

CalsLib

Data Analysis

I need to generate 12 random (even) numbers from a give set of numbers 1--24.
How do I get excel to do this?

Thanks

Niek Otten

Data Analysis

=RANDBETWEEN(1,12)*2

Copy down so you have 12 rows

--
Kind regards,

Niek Otten

"CalsLib" wrote in message ...
I need to generate 12 random (even) numbers from a give set of numbers 1--24.
How do I get excel to do this?

Thanks

All times are GMT +1. The time now is 03:36 PM.