Does it have to be a formula?
I'd use data|filter|advanced filter.
Debra Dalgleish describes it he
http://contextures.com/xladvfilter01.html#FilterUR
lightbulb wrote:
Is there a formula or macro I can use that on 'Sheet 1' column F will give me
each unique value from column D in sheet 'Exp Data' .... in other words it
will go through and list each different input from Column D in 'Exp Data' in
Column F of 'Sheet 1'...
Any help?
Thanks!
--
Dave Peterson