Forum Discussion
Solved
Filter Values in a Column That Only Occur an Odd Number of Times
Hello. I have a spreadsheet with a column of invoice amounts and I want to see only those values that appear in the column an odd number of times. I've attached an example of my spreadsheet. I have...
I'd add a helper column: in D2, enter the formula
=ISODD(COUNTIF($C$2:$C$24,C2))
and fill down.
You can now filter the range on column D for TRUE.
I'd add a helper column: in D2, enter the formula
=ISODD(COUNTIF($C$2:$C$24,C2))
and fill down.
You can now filter the range on column D for TRUE.
Thank you, Hans! I've been looking at this for 2 days and the solution is so simple. I was definitely making this harder than it had to be! Thanks again and have a great day.