Extract Unique Values From Column In One Sheet and Populate Unique Values In Another Sheet

Hi,

Is there a formula that I could use to extract the unique values from a column in one sheet and populate those unique values in another sheet? So in the attached, sheet 1 has a list in column A that in sheet 2, I'd like to list only the unique values. Thanks in advance!!

Originally Posted by tigeravatar

rlh06,

Welcome to the forum!
Using your provided example workbook, on Sheet2 in cell A1 put a header like "Unique Values"
Then in Sheet2 cell A2 put this formula and copy down:

Please Login or Register  to view this content.

Thanks, brother!

That rocks the casbah!