Forum Discussion

i_dewstow's avatar
i_dewstow
Copper Contributor
Apr 21, 2020

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!

 

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Apr 21, 2020
    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

Resources