Dear Excel Expertise,
I had an error which I googled showing the meaning is that my formula is too long (>255 chars). I tried to cut them into lines like below but I still got the same error. Can anybody be kind enough to correct my formula, please? I have tried to troubleshoot for hours..
Thank you in advance.
DZ
I had an error which I googled showing the meaning is that my formula is too long (>255 chars). I tried to cut them into lines like below but I still got the same error. Can anybody be kind enough to correct my formula, please? I have tried to troubleshoot for hours..
Code:
Selection.FormulaArray = _
"=IFERROR(IF(RC7=MIN(IF(INDIRECT(""A2:A""&COUNTA(C[-7]))=RC1," & _
"IF(INDIRECT(""F2:F""&COUNTA(C[-7]))=RC6,INDIRECT(""G2:G""&COUNTA(C[-7])),""""),""""))," & _
"IF(OR(OR(RC6=""NGIN_SERVICE"",RC6=""NGIN_PBO"",RC6=""NGIN_MS"")," & _
"OR(RC6=""NGIN_DISPUTE-NON_PBO"",RC6=""NGIN_DISPUTE_NON_PBO"",RC6=""HQ_PREPAID"")," & _
"RC6=""HQ_CAS""),""Huawei"",""""),""""),"""")"
Thank you in advance.
DZ