K Kenshin Member Jun 6, 2020 #1 hi guys nice to meeting you here, need for assistance again, please take a look at the file thank you Attachments Ask for Help.xlsx 10.6 KB · Views: 11
hi guys nice to meeting you here, need for assistance again, please take a look at the file thank you
AliGW Well-Known Member Jun 6, 2020 #2 In L5 copied across and down: =IFNA(LOOKUP(2,1/(($C$3:$J$3=L$3)*($C5:$J5>0)),$C5:$J5),0)