Please help me find the date that meet the criteria.
F Farhad Sam New Member Nov 18, 2021 #1 Please help me find the date that meet the criteria. Attachments Test.xlsx 18.4 KB · Views: 2
B bosco_yip Excel Ninja Nov 18, 2021 #2 Try, [J3] =LOOKUP(H3, SUBTOTAL(9,OFFSET(A3,,,,COLUMN($A$2:$G$2))),$A$2:$G$2) [M6] =LOOKUP(K6, SUBTOTAL(9,OFFSET(D6,,,,COLUMN($D$5:$J$5)-COLUMN($D$5)+1)),$D$5:$J$5) Regards
Try, [J3] =LOOKUP(H3, SUBTOTAL(9,OFFSET(A3,,,,COLUMN($A$2:$G$2))),$A$2:$G$2) [M6] =LOOKUP(K6, SUBTOTAL(9,OFFSET(D6,,,,COLUMN($D$5:$J$5)-COLUMN($D$5)+1)),$D$5:$J$5) Regards