Unique Values in a list - Is there a way to do this?

[TigersLions]

In excel worksheet tab 1 I have a list of duplicate values.

In excel worksheet tab 2, I want it to draw from tab 1 ONLY the unique values.

Is there a way to do this WITHOUT having to do a copy and paste and filter for unique values? I want the unique values in tab 2 to update every month automatically based on what I put into tab 1.

I've done some googling and haven't come up with a good answer. I may not be using the right search term so I thought I would try here.

Thanks!!

 

[stuartnico]

Not sure I understand you have a remove duplicates button in the data tab. Thus leaving only unique then so a lookup between the two tables.

 

[TigersLions]

Not sure I understand you have a remove duplicates button in the data tab. Thus leaving only unique then so a lookup between the two tables.

WOW! I've never even noticed that before!!! Thank you. I'm all set..

 

[stuartnico]

No problem - believe me its frustrating trying to find the answers online at the best of times this place has helped me so many times decided its about time I joined up and help out when I can. I'm not as clever as half the bods on here but makes a change being able to help someone else. Enjoy your excel fun....