Perhaps you need helper column, and the array formula is
put in D2 and entered as array and copied down
=IFERROR(INDEX($F$2:$F$7,MATCH(0,COUNTIF(D1:$D$1,$F$2:$F$7)+IF(COUNTIF($F$2:$F$7,$F$2:$F$7)>1,0,1),0)),"")
Perhaps you need helper column, and the array formula is
put in D2 and entered as array and copied down
=IFERROR(INDEX($F$2:$F$7,MATCH(0,COUNTIF(D1:$D$1,$F$2:$F$7)+IF(COUNTIF($F$2:$F$7,$F$2:$F$7)>1,0,1),0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks