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..
Please Login or Register to view this content.
Thank you in advance.
DZ
Does the formula work if you copy it from below and paste it in the cell?
=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",""),""),"")
Entia non sunt multiplicanda sine necessitate
If you put the OR comparison values in a Range, you could replace this...
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"), ...
With something like this...
IF(ISNUMBER(MATCH(RC6,Z1:Z10,0)), ...
Where Z1:Z10 is the list range (convert that to R1C1 refernce)
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
That's a fine idea.
Here's another way:
Please Login or Register to view this content.
Last edited by shg; 04-12-2016 at 08:34 PM.
Yes, it does, shg. I will record first before I amend the line of rows for the range of data in the editor.
Ouh, this one I will try by EOD. Really appreciate the effort. Thanks!Originally Posted by shg
The code inserts your formula (I checked). But AF's suggestion of making the formula shorter is a better place to start, IMO. It would make the formula easier to understand, for one thing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks