azumi Active Member Jul 1, 2019 #1 Nice meet you again Ninjaz, please take a loook at my file needand desperate to get help using formula thank you Attachments Question.xlsx 9.2 KB · Views: 14
Nice meet you again Ninjaz, please take a loook at my file needand desperate to get help using formula thank you
AliGW Well-Known Member Jul 1, 2019 #2 Try this in H2 copied down: =IFNA(INDEX(B$1:B1,MATCH(C2,C$1:C1,0)),"")
B bosco_yip Excel Ninja Jul 1, 2019 #3 In H2, copied down to H11 : =IF(COUNTIFS(F$1:F2,F2,G$1:G2,G2)=1,"",INDEX(B:B,AGGREGATE(15,6,ROW($B$2:$B$11)/($C$2:$C$11=F2)/($D$2:$D$11=G2),COUNTIFS(F$1:F2,F2,G$1:G2,G2)-1))) Regards Bosco
In H2, copied down to H11 : =IF(COUNTIFS(F$1:F2,F2,G$1:G2,G2)=1,"",INDEX(B:B,AGGREGATE(15,6,ROW($B$2:$B$11)/($C$2:$C$11=F2)/($D$2:$D$11=G2),COUNTIFS(F$1:F2,F2,G$1:G2,G2)-1))) Regards Bosco
azumi Active Member Jul 1, 2019 #4 Thanks Ali but its not working for the last criteria, it return 13/05/2019, it should return 08/06/2019
Thanks Ali but its not working for the last criteria, it return 13/05/2019, it should return 08/06/2019
AliGW Well-Known Member Jul 1, 2019 #6 azumi said: Thanks Ali but its not working for the last criteria, it return 13/05/2019, it should return 08/06/2019 Click to expand... It would have helped if you had explained what the aim was instead of just providing a workbook. Too little information!
azumi said: Thanks Ali but its not working for the last criteria, it return 13/05/2019, it should return 08/06/2019 Click to expand... It would have helped if you had explained what the aim was instead of just providing a workbook. Too little information!
