Compare data in multiple cells in one row with those in other

[gtg174q]

Guys,

I got several columns and rows of data. For a given criteria in column A, I want to compare the data in rest of the column for that row with the rest of the columns in another row. We are comparing same number of columns; however, those data aren't sorted. I just want to know if all the values in one row is repeated in another row or not.

Any idea how to do this?

Thanks for any help and hopefully following example would clarify what I am looking for.

For e.g.

Below, let's say I want to compare Mary and Mark. Once I id which rows these two names are located at (which I can do), I need to compare Mary's data with Mark's (their last name, address and tel#.). It would return TRUE for Mary and Mark and FALSE for Mark and Shane or Mary and Shane. However, these data (last name, address, tel #, email id) aren't always in the same column like below. However, first col always has first name. I just made up some crap below.

First Name Last Name Address Tel # email id
John McCarthy 123 Whatever ###-###-#### pleasedonotreply@gmail.com
Jenn William 124 Whatever ###-###-#### pleasedonotreply@gmail.com
Mary Smith 125 Whatever ###-###-####
Mark Smith 125 Whatever ###-###-#### pleasedonotreply@gmail.com
Shane Smith 127 Whatever ###-###-#### pleasedonotreply@gmail.com
George Day 128 Whatever ###-###-#### pleasedonotreply@gmail.com
Brenda Young 129 Whatever ###-###-#### pleasedonotreply@gmail.com

 

[daniels012]

probably the easiest way is using from the menu bar >Data>Filter>AutoFilter

Michael