Sorting Spreadsheet by duplicate values

[i_dewstow]

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!

[#2]

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