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
=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