In my Excel file, I have 16,000 rows. In column AH, I have a number from 1 through 400 so that there are 40 of each number in column AH in the entire spreadsheet.
I have to split the sheet into multiple sheets to send to four different people. Each person should get 4,000 rows, which will contain 100 of the numbers in column AH. I cannot split the numbers in column AH among different people. So, for example, each of the 40 rows that have AH=100 must go to the same person.
I could simply send AH=1-100 to one person, AH=101-200 to the second person, etc. However, it is important that the AH numbers each person gets are NOT sequential.
I was thinking I could create a new column with another random number from 1 through 400 and split it according to that. But is there a way to make sure that each row that has the same AH number gets the same random number?
Any ideas would be greatly appreicated...