Dear Sir, please help to resolve the issue. Example file attached for your kind information.
S sambit Member Jul 13, 2019 #1 Dear Sir, please help to resolve the issue. Example file attached for your kind information. Attachments Example.xlsx 11.2 KB · Views: 12
XOR LX Active Member Jul 13, 2019 #2 Hi, In L3: =IF(COUNTIFS(B:B,B3,C:C,C3,D:D,D3,E:E,E3,F:F,F3,G:G,G3,H:H,H3,J:J,"<"&K3),"Excess","") and copied down. Regards
Hi, In L3: =IF(COUNTIFS(B:B,B3,C:C,C3,D:D,D3,E:E,E3,F:F,F3,G:G,G3,H:H,H3,J:J,"<"&K3),"Excess","") and copied down. Regards
S sambit Member Jul 13, 2019 #3 XOR LX said: Hi, In L3: =IF(COUNTIFS(B:B,B3,C:C,C3,D:D,D3,E:E,E3,F:F,F3,G:G,G3,H:H,H3,J:J,"<"&K3),"Excess","") and copied down. Regards Click to expand... XOR LX Sir, Excellent Thank you very much.
XOR LX said: Hi, In L3: =IF(COUNTIFS(B:B,B3,C:C,C3,D:D,D3,E:E,E3,F:F,F3,G:G,G3,H:H,H3,J:J,"<"&K3),"Excess","") and copied down. Regards Click to expand... XOR LX Sir, Excellent Thank you very much.