Forum Discussion
Solved
How can I filter out rows that have duplicate values in adjacent columns?
I am trying to filter out rows with duplicate values that appear in adjacent columns. Full disclosure, its been years since I used Excel in any meaningful way. Any help is much appre...
You may create a helper column (say in column E) with the following formula...
=C2=D2This formula will return TRUE when values in columns C and D are the same and FALSE if they are different and then you may apply the Filter and choose TRUE or FALSE as per your requirement.
Please refer to the attached with formula in place.
You may create a helper column (say in column E) with the following formula...
=C2=D2This formula will return TRUE when values in columns C and D are the same and FALSE if they are different and then you may apply the Filter and choose TRUE or FALSE as per your requirement.
Please refer to the attached with formula in place.
- That did the trick.
