Unique values in Excel/VBA

[jrec]

I want to create a list of unique values from a range of values in Excel. Normally you can use the "Advanced Filter" option, but as I want to share the workbook, this option is no longer valid. Are there any other ways to do this?

Thanks!

 

[dsi]

You could insert a pivot table or fill an array in VBA. The pivot table is a breeze, though.

 

[DaleWatson123321]

jrec,

I just want to confirm, in case you aren't aware... that Excel DOES allow you to extract a Unique list to a SEPARATE sheet - in spite of a FALSE ERROR message that says you can NOT.

If you want additonal help in this area, let me know, care of the address below if you like.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca