Answer for:

how to match data from three columns in an excel

Message 7 of 6

View entire thread
1 Votes

Assuming your new column is "D" and the data starts on row "2". Copy this formula into cell "D2". Then copy and past to the end of your data.


The sort of the data really makes no difference as long as each record is unique. Hope this helps.