Need to dictate for data in two columns that A,B = B,A
I need to sort several columns of data by the information in only two, but not as a nested sort.
Columns A and B each contain individuals 1-13, column A as actor, column B as recipient. I want to tell excel to identify the pairing 1,3 as the same pair as the pairing 3,1 and to label all of those pairings as "pair 1-3."
|