Index, Match CountIf Formula

[zone709]

So I use this formula on a sheet I have now which works fine but I would like to use it pulling from another tab on my sheet.

=IFERROR(INDEX(D$2:D$306,MATCH(0,INDEX(COUNTIF(D$1:D1,D$2:D$306),0),0)),"")

Basically I want to pull the D$2:D$306 from a tab called Detailed_View.

Not sure how i would fit Detailed_View in after =IFERROR(INDEX & after the Countif

Thanks

 

[zone709]

Works thanks guys. I just updated my account profile.

 

[Fluff]

I just updated my account profile.

Many thanks for that