Sorting Spreadsheet by duplicate values

%3CLINGO-SUB%20id%3D%22lingo-sub-1326473%22%20slang%3D%22en-US%22%3ESorting%20Spreadsheet%20by%20duplicate%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1326473%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20wanting%20to%20know%20how%20I%20can%20sort%20my%20spreadsheet%20based%20on%20the%20duplicate%20values%20that%20appear%20while%20deleting%20the%20blank%20unique%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20help%20would%20be%20much%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1326473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1326557%22%20slang%3D%22en-US%22%3ERE%3A%20Sorting%20Spreadsheet%20by%20duplicate%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1326557%22%20slang%3D%22en-US%22%3EI%20don't%20understand%20exactly%20what%20you%20want%2C%20but%20a%20simple%20way%20you%20can%20'tag'%20duplicates%20is%20add%20a%20column%20and%20use%20the%20formula%20like%20%3Dcountif(b%3Ab%2Cb1)%20which%20would%20tell%20you%20how%20many%20duplicates%20of%20the%20value%20in%20column%20b%20exist.%20you%20could%20then%20sort%20by%20that%20'tag'%20column%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

I am wanting to know how I can sort my spreadsheet based on the duplicate values that appear while deleting the blank unique cells.

 

any help would be much appreciated!

 

1 Reply
Highlighted
I don't understand exactly what you want, but a simple way you can 'tag' duplicates is add a column and use the formula like =countif(b:b,b1) which would tell you how many duplicates of the value in column b exist. you could then sort by that 'tag' column