Cell C10 formula , Drag down and across
Formula:
=IFERROR(INDEX($2:$2,AGGREGATE(15,6,COLUMN($D$2:$N$2)/(($A$3:$A$5=$A10)*($D$3:$N$5=1)),COLUMN(A$1))),"")
Cell C10 formula , Drag down and across
Formula:
=IFERROR(INDEX($2:$2,AGGREGATE(15,6,COLUMN($D$2:$N$2)/(($A$3:$A$5=$A10)*($D$3:$N$5=1)),COLUMN(A$1))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks