In an Excel worksheet, I have a rectangular region (`C3:G7`

in the image below)
that contains people’s names (e.g., Paul, John, Frank, etc.)
I want to

- Create a unique (de-duped) linear list of names
(in Column
`B`

;`B9:B20`

in the image below, but the number of rows depends on the number of unique names in the input range). - In Column
`C`

(`C9:C20`

), count the number of times each name appears in the input. (This is easy to do with`COUNTIF`

.) Sort the output list (

`B9:C20`

) by count (descending).

To reiterate: rows 2 to 7 are the input (`B3:B7`

can be ignored)
and rows 9 to 20 are the output.
I’m stuck on the first step (generating the de-duped list of names)
and I could use some help on the third step (sorting the output) too.

`COUNTIF`

: exceljet.net/excel-functions/excel-countif-function – Fabian Röling Nov 8 at 21:53