E
Exceluser24/7
I'm being asked to create a "master spreadsheet" that includes information
for over 500 school districts. I'm bringing together several different data
sets into one sheet. I'm arranging data by hand, which is time consuming.
How can I arrange data in one column to exactly match data in another column?
That is, with two columns:
Column 1 Column 2 -a function that will do the following-
Column 2
School A School B
School A
School B School A
School B
School C School C
School C
for over 500 school districts. I'm bringing together several different data
sets into one sheet. I'm arranging data by hand, which is time consuming.
How can I arrange data in one column to exactly match data in another column?
That is, with two columns:
Column 1 Column 2 -a function that will do the following-
Column 2
School A School B
School A
School B School A
School B
School C School C
School C