View Single Post
  #1   Report Post  
desertanimal desertanimal is offline
Junior Member
 
Posts: 2
Default 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."