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
B9:B20in the image below, but the number of rows depends on the number of unique names in the input range).
- In Column
C9:C20), count the number of times each name appears in the input. (This is easy to do with
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.