Filter Values in a Column That Only Occur an Odd Number of Times

New Contributor

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.

2 Replies
best response confirmed by amyjh38 (New Contributor)


I'd add a helper column: in D2, enter the formula


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.