1

MS Excel: query for rows where cell A & B are identical but C is different?

view story
linux-howto

http://superuser.com – I'm trying to clean up some really bad data that I inherited and I'm looking for a way to 'ask' Excel to somehow bring to my attention all rows where cell A & B match but cell C is different. Example: A B C 1 cat dog cow 2 cat rat cow 3 cat pig ant 4 cat dog pig 5 cat dog cow 6 cat rat cow 7 gnu rat cow Put another way. I want rows 1, 4 & 5 to be brought to my attention because A & B match but C is different. I'd settle for just one of those (1, 4 or 5) to be brought to my attention (HowTos)