SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2350999%22%20slang%3D%22en-US%22%3EFilter%20Values%20in%20a%20Column%20That%20Only%20Occur%20an%20Odd%20Number%20of%20Times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350999%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%20I%20have%20a%20spreadsheet%20with%20a%20column%20of%20invoice%20amounts%20and%20I%20want%20to%20see%20only%20those%20values%20that%20appear%20in%20the%20column%20an%20odd%20number%20of%20times.%20I've%20attached%20an%20example%20of%20my%20spreadsheet.%26nbsp%3B%20I%20have%20searched%20for%20help%20but%20I%20haven't%20been%20able%20to%20find%20anything.%26nbsp%3B%20I%20apologize%20if%20this%20has%20already%20been%20answered%20and%20I%20just%20didn't%20use%20the%20correct%20key%20words%20to%20search.%26nbsp%3B%20I%20have%20Windows%2010%20version%2020H2%2C%20Microsoft%20Office%20365%20Version%202008(Build%2013127.21506%20Click-to-Run)%2064-bit%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2350999%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2351069%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Values%20in%20a%20Column%20That%20Only%20Occur%20an%20Odd%20Number%20of%20Times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2351069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1052984%22%20target%3D%22_blank%22%3E%40amyjh38%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20add%20a%20helper%20column%3A%20in%20D2%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%3DISODD(COUNTIF(%24C%242%3A%24C%2424%2CC2))%3C%2FP%3E%0A%3CP%3Eand%20fill%20down.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0402.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280483i6676B7CF749996C0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0402.png%22%20alt%3D%22S0402.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20can%20now%20filter%20the%20range%20on%20column%20D%20for%20TRUE.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0403.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280485i1DE4538E75BD6552%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0403.png%22%20alt%3D%22S0403.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
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)
Solution

@amyjh38 

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

=ISODD(COUNTIF($C$2:$C$24,C2))

and fill down.

S0402.png

You can now filter the range on column D for TRUE.

S0403.png

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.