Spliting a list into two identical lists

[alissa.swartz]

Hello –

I am trying to create two spreadsheets that have an equal distribution of people across two different indicators - 39 locations & 2 years. The original spreadsheet has a list of approx 9500 people, reflecting a distribution across 39 different locations and 2 years. So, each of the two new spreadsheets would have 4750 people, with the same distribution of 39 locations and two years.



My initial idea was to either assign a “1” or a “2” to each person, and then create two excel files based on the number I assign them. Does anyone know how to assign a “1” or a “2”, apart from doing it manually? Or, is there an alternative way to accomplish creating two new lists?

Thanks much.

 

[VoG]

You could use in a spare column

=RANDBETWEEN(1,2)

and copy down. Then filter on that column for 1 or 2 and copy to the respective sheets.