Not what I needed

  • Thread starter Thread starter J Donahue
  • Start date Start date
J

J Donahue

I am looking for a formula I can use to extract this list,
not a copy and paste. I would like to have a formula I
can use to extract the unique items in a list.
 
I am not sure I like the tone of your last posting, this is a peer to peer
NG and not
paid MS support

Anyway I assume you are new to this, list in Sheet2 A2:A100, assume you want
this in Sheet1 A2 going down

array enter this formula in Sheet1 A2 and copy down until you get an error

=INDEX(Sheet2!$A$2:$A$100,MATCH(0,COUNTIF($A$1:A1,Sheet2!$A$2:$A$100),0))

(array enter = ctrl + shift & enter)
 
I did not mean any disprespect due to my previous post. I
was merely trying to state that the copying and filtering
of the list would not work for what I needed.

Again, sorry if it came out the wrong way.

And thank you for the formula, it seems to work perfectly
for my needs.

J Donahue
 
Back
Top