Forum Discussion
Sorting Spreadsheet by duplicate values
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!
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