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

gtg174q

New Member
Joined
Nov 14, 2007
Messages
4
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
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
probably the easiest way is using from the menu bar >Data>Filter>AutoFilter

Michael
 

Watch MrExcel Video

Forum statistics

Threads
1,098,991
Messages
5,465,863
Members
406,451
Latest member
KARANDREA

This Week's Hot Topics

Top