I have 3 columns of data, within each column each data piece will be unique, but will be duplicated across 1 or both of the other columns. for notes a single cell will contain a value that looks like this "511VSB643770000201"
But for illustration lets pretend that each cell contains a persons name.
Column A contains the names of people (note that the nature of the data, there are no duplicate names in a single list) in a school in January.
Column B contains All the names of people that have ever been in the school between January and August (the master list).
Column C contains the name of people in the school in August.
I wish to sort columns A and C against B, keeping B's original ordering. (I cannot see a way to add more text after the table I have added, so I'll post how it should look in a reply to this thread)
<tbody>
</tbody>
But for illustration lets pretend that each cell contains a persons name.
Column A contains the names of people (note that the nature of the data, there are no duplicate names in a single list) in a school in January.
Column B contains All the names of people that have ever been in the school between January and August (the master list).
Column C contains the name of people in the school in August.
I wish to sort columns A and C against B, keeping B's original ordering. (I cannot see a way to add more text after the table I have added, so I'll post how it should look in a reply to this thread)
Alex | Alex | |
James | James | |
Alex | Luke | Luke |
Ben | Jacob | Jacob |
Hillary | Ben | Justin |
Jack | Zack | Clyde |
Jack | Zack | |
Hillary | ||
Justin | ||
Clyde |
<tbody>
</tbody>