Hi there,
It's interesting how many interpretations can be put on a query
On reading your query,my initial reaction was that you wanted a random number between 1 and 4 generated 15 times, a random number between 2 and 4 generated 20 times, a random number between 3 and 4 generated 25 times - not sure why you'd want a random number between 4 and 4 generated 40 times, but who knows????
Anyway, going with my initial reaction, enter the following formula into Cell B2 and copy it downwards:
Please let me know how much I've misinterpreted your query!
Regards,
Greg M
Bookmarks