| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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." |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can selection from text drop-down dictate value in another cell | Excel Worksheet Functions | |||
| Sorting Data into columns without replacing the columns with data | New Users to Excel | |||
| Text to dictate colour of the cell and/or row | Excel Worksheet Functions | |||
| How do I dictate cell to cell progression in a protected worksheet | Excel Worksheet Functions | |||
| Dictate physical size of pictures inserting into Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
