Wa 'alaikumusalam Warahmatulah Wabarakatuh Dear Cheivory, Coba di H2 Diketik formula:=IF(COUNTIFS($B$2:B2,B2,$G$2:G2,">="&F2)>1,"sedang state "&INDEX(Table1[STASE],MATCH(B2,Table1[NIM],0)),"")
Copy ke bawah
Wasalamu'alaikum Warahmatulah Wabarakatuh NangAgus On 12/22/2018 10:17, [email protected] [belajar-excel] wrote:
Yth. B-Exceller Assalaamu'alaikum Wr Wb Mohon kiranya dapat membantu menyelesaikan kasus terlampir. Terima kasih. Wassalaamu'alaikum Wr Wb Ari
