Select 3 equal cels

%3CLINGO-SUB%20id%3D%22lingo-sub-1604250%22%20slang%3D%22en-US%22%3ESelect%203%20equal%20cels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604250%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20people%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%204%20cels.%20Three%20are%20equals%20and%201%20different.%20I%20want%20to%20select%203%20equal%20cels%2C%20because%20I%20need%20to%20dell%20this%20one%20different.%20Well%2C%20I%20have%20a%20long%20list%20with%20this%20situation.%3C%2FP%3E%3CP%3EI%20tried%20with%20Remove%20Duplicate%20tool%2C%20but%20it%20selects%202%20cells%20and%20more.%3C%2FP%3E%3CP%3EI%20just%20need%20to%20select%203%20cells.%3C%2FP%3E%3CP%3ESorry%20about%20my%20English.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605731%22%20slang%3D%22en-US%22%3ERe%3A%20Select%203%20equal%20cels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767191%22%20target%3D%22_blank%22%3E%40rasga2000%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20want%20the%20output%20like%20below%20image%2C%20then%20see%20attached%20excel%20file%20for%20the%20required%20formula.%20If%20this%20is%20not%20what%20you%20wanted%2C%20then%20please%20upload%20an%20example%20excel%20file%20which%20has%20sample%20input%20data%20and%20typed%20output%20data%20as%20you%20want%20it%20to%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22amit_bhola_0-1598117573963.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213981i0FAA5D9037044B08%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22amit_bhola_0-1598117573963.png%22%20alt%3D%22amit_bhola_0-1598117573963.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi people,

 

I have 4 cels. Three are equals and 1 different. I want to select 3 equal cels, because I need to dell this one different. Well, I have a long list with this situation.

I tried with Remove Duplicate tool, but it selects 2 cells and more.

I just need to select 3 cells.

Sorry about my English.

 

1 Reply

@rasga2000 , if you want the output like below image, then see attached excel file for the required formula. If this is not what you wanted, then please upload an example excel file which has sample input data and typed output data as you want it to be.

 

amit_bhola_0-1598117573963.png