I am making a raffel sheet. Each sheet has 50 numbers from 1 -1000 with no duplication. For a total of 1000 possible choices.
I would like Excel to generate 20 sheets of 50 random numbers no duplicates. Then on seperate sheet have excel tell me by 1-1000 which of the 20 pages I will find that number.
as an example
Page 1 has
3 5 501 652 75 on the first line
then on second sheet
it will list
#3 page 1
#5 Page 1
#75 Page 1
#501 Page 1
#652 Page 1
sheet 2 will be in numerical order. 1-1000 in first coloum and 1-20 to define which sheet.
I have Excel 2021, would be nice to be backwards compatile to office 2013 or Google sheets
AlohaRoss
An Aloha POS 3rd Party support Solution company.
We answer when they don't
reddit : rossabout
I would like Excel to generate 20 sheets of 50 random numbers no duplicates. Then on seperate sheet have excel tell me by 1-1000 which of the 20 pages I will find that number.
as an example
Page 1 has
3 5 501 652 75 on the first line
then on second sheet
it will list
#3 page 1
#5 Page 1
#75 Page 1
#501 Page 1
#652 Page 1
sheet 2 will be in numerical order. 1-1000 in first coloum and 1-20 to define which sheet.
I have Excel 2021, would be nice to be backwards compatile to office 2013 or Google sheets
AlohaRoss
An Aloha POS 3rd Party support Solution company.
We answer when they don't
reddit : rossabout