Copy array formula down the column

[ClarityNDT]

Good afternoon,

I have an array formula that is creating a list of unique values from another portion of the sheet.

I want to generate a list of unique values from cells w3 through w141 in cells w150 through w290

I have the following array formula which seems to work:

 =INDEX($W$3:$W$141,MATCH(0,COUNTIF($W$149:$W$290,$W$3:$W$141),0))

this correctly returns the 1st value from w3:w141 which is "alpha"

It seems i need this code in all of the cells w150:w290 but I cannot drag the formula down, as all the cells return "alpha". If i manually enter then exit each cell using crtl+shift+ent it works.

Anyway to quickly paste this?

 

[Fluff]

Put this in W150 & then drag down

=INDEX($W$3:$W$141,MATCH(0,COUNTIF($W$149:$W149,$W$3:$W$141),0))

 

[ClarityNDT]

Superstar.

 

[Fluff]

Glad to help & thanks for the feedback.