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!

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

Assuming your data is in Range A1:A12 - yype the hereunder suggested
Array-Formula and press CTRL+SHIFT+ENTER, at the same time, rather then just
ENTER.
DO NOT type the curly braces { }. Excel will display them automatically !
Now you are ready to copy down along col. B
=LARGE((FREQUENCY($A$1:$A$20,$A$1:$A$20)0)*($A$1: $A$21),ROW())
Micky


"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!