Dear Sir, Plz help to resolve the issue. Example file attached for your kind information.
S sambit Member Mar 13, 2020 #1 Dear Sir, Plz help to resolve the issue. Example file attached for your kind information. Attachments Example.xlsx 8.5 KB · Views: 14
B bosco_yip Excel Ninja Mar 13, 2020 #2 Try.......... In H5, formula copied down : =IF((COUNTIF(E$5:E$15,E5)>1)*COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)=COUNTIF(E$5:E$15,E5)*ISODD(COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)),"Single","Multiple") Regards Bosco
Try.......... In H5, formula copied down : =IF((COUNTIF(E$5:E$15,E5)>1)*COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)=COUNTIF(E$5:E$15,E5)*ISODD(COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)),"Single","Multiple") Regards Bosco
S sambit Member Mar 13, 2020 #3 Bosco Sir, Thank you very much. sir, I have little bit changes of Remark column plz help to resolve the issue example file attached. Attachments Example.xlsx 9.2 KB · Views: 8
Bosco Sir, Thank you very much. sir, I have little bit changes of Remark column plz help to resolve the issue example file attached.
S sambit Member Mar 13, 2020 #4 Bosco Sir, Please Ignore Earlier Attachment. Plz find the correct file attachment "Example Modify" Attachments Example_Modify.xlsx 9.2 KB · Views: 12
B bosco_yip Excel Ninja Mar 13, 2020 #5 Then, In H5, formula copied down : =IF(COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)=COUNTIF(E$5:E$15,E5)*ISODD(COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)),"Single","Multiple") Regards Bosco
Then, In H5, formula copied down : =IF(COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)=COUNTIF(E$5:E$15,E5)*ISODD(COUNTIFS(E$5:E$15,E5,F$5:F$15,F5)),"Single","Multiple") Regards Bosco