paramveer Member Sep 15, 2018 #1 Sir, please help to find a greater date between two table explained in attached file. Thanks in advance Attachments QUESTION.xlsx 9.3 KB · Views: 14
Sir, please help to find a greater date between two table explained in attached file. Thanks in advance
B bosco_yip Excel Ninja Sep 16, 2018 #2 Maybe, G10, copied down : =MIN(LARGE(A$1:A$27,COUNTIF(A$1:A$27,">="&F10)),IFERROR(LARGE(G$2:G$5,COUNTIF(G$2:G$5,">="&F10)),9^9)) Regards Bosco
Maybe, G10, copied down : =MIN(LARGE(A$1:A$27,COUNTIF(A$1:A$27,">="&F10)),IFERROR(LARGE(G$2:G$5,COUNTIF(G$2:G$5,">="&F10)),9^9)) Regards Bosco
paramveer Member Sep 16, 2018 #3 thank you so much , its solve my problem Last edited by a moderator: Sep 24, 2018
