Share via

Unique Function - Skip a row (Input and Output)

Anonymous
2022-01-15T15:29:39+00:00

I'm trying to get a unique list of names from a list. The list is continuously growing, so I'd like to apply the Unique Function to the full column, except for the first row (which is the title info). ALSO, I need the output to skip a row as well. Can someone help? Thanks!

Microsoft 365 and Office | Excel | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-15T15:55:58+00:00

    Re: unique list from multiple selections

    Make multiple selections and get the unique count...

    '------------------------------------------------------------------------------------------

    The unique list is placed in the first set of blank columns to the right of the data.

    The above created by the 'List Unique Items' utility found in the free "Professional_Compare" workbook.

    Download the free workbook from OneDrive... https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    '---

    Nothing Left to Lose

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments