Forum Discussion
Solved
How to identify if Rows that have a matching value - does a specific column also have matching data?
I need a formula that will tell me for each row that has a value of "1" in column A - do the values in column B match? (i.e. For all numbers that say "1" column B should say expired for all of those,...
Enter the following formula in C2, then fill down:
=COUNTA(UNIQUE(FILTER($B$2:$B$10000, $A$2:$A$10000=A2)))>1
This will return TRUE for the rows of numbers with more than one unique problem.
You can sort or filter on column C if desired.
Enter the following formula in C2, then fill down:
=COUNTA(UNIQUE(FILTER($B$2:$B$10000, $A$2:$A$10000=A2)))>1
This will return TRUE for the rows of numbers with more than one unique problem.
You can sort or filter on column C if desired.