Posts by dra_red

    Re: Generate a list of unique values

    So many ways to do the same thing...

    Here is another. A way to create a dynamic list with Excels internal functions.

    Insert a column (or use a new worksheet) and add a 'countif' function in this column. Use relative referencing so that the countif function only counts the items in the range above the actual item.

    Rows in the new column will show '1' for the first instance and '>1' for any more instances.

    You can then use a filter or a Vlookup (after some manipulation to get it how you want) to create the unique list where you want.

    No macros required.

    Cheers, Dale