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 searched for help but I haven't been able to find anything. I apologize if this has already been answered and I just didn't use the correct key words to search. I have Windows 10 version 20H2, Microsoft Office 365 Version 2008(Build 13127.21506 Click-to-Run) 64-bit Thank you.
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.
