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!