Comparing multiple values

**Iskoban** · 10-07-2013, 11:14 AM

Hi all,

I have a large set of data (approx. 3500 records) with the following structure:

Name Location Status
Name 1 Location 1 Expired
Name 1 Location 1 Active
Name 2 Location 2 Active
Name 2 Location 1 Active

What I would like to do is to perform a check on the status for every single identify (in this case Name 1). My goal is to check whether there are differences in the status per identity.

I have tried to use the 'exact' function, but as i have about 3500 records, and the identities are listed on alphabetical order, is it kind of hard to get the right result.

Can anyone of you point me to the right direction? Are there any other functions within Excel that might work better?

Thanks in advance!

**Pauleyb** · 10-07-2013, 05:51 PM

Not sure how you want to show your check as positive or negative. Maybe a helper column which compares the name and location on the current row with the name and location on the row below. If they are the same, but the status is different, then output 'Difference' else Blank. You could use similar logic and utilize conditional formatting, if color would be a better way to show a delta. The formula would be somethnig like:
=IF(AND(A1=A2, B1=B2, C1<>C2),"Difference","")

**FDibbins** · 10-07-2013, 05:54 PM

Hi and welcome to the forum

Another option would be to use a helper to combine all 3 cells =A1&B1&C1 and then use countif() to count the duplicates?

Comparing multiple values

LinkBack

Thread Tools

Rate This Thread

Display

Comparing multiple values

Re: Comparing multiple values

Re: Comparing multiple values

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Comparing cell values in different sheets based on multiple reference values as conditions

[SOLVED] Comparing Multiple Values

[SOLVED] Comparing multiple cells and values

Comparing one value to multiple values

Bookmarks

Bookmarks

Posting Permissions