Annoying message "Excel found a problem with one or more formula...."

[tico_ocit]

Hi there,
PLEASE HELP!!!!

I'm desperate with this annoying error messaing!


Can I make it not to show? Application.displayalerts=False , is not working!
I have named ranges, but of course, if the sheet has no data, the ranges and the graphs attached to that no work. But I know that!
I just don't want to appear!!!

Can someone tell me a work around to it?

Thank you in advance!

 

[tico_ocit]

I was too slow to edit my reply above, hopefully this will help with the explanation.

That's it! Now I can have 0 between the months, and the chart draws it! That's amazing!
What is frustating me is I can't understand this! =IFERROR(AGGREGATE(14,6,COLUMN($C$4:$N$4)/(INDEX($C:$N,V4,0)<>0),1)-COLUMN($C$4)-V5+1,1) .
COLUMN({3,4,5,6,7,8,9,10,11,12,13,14})/({0,0,1,2,0,1,5,0,0,0,0,0}<>0) in this array on your example would be, COLUMN({3,4,5,6,7,8,9,10,11,12,13,14})/({0,0,0,0,581,0,892,311,0,0,0,0}<>0).
Eventhough what returns? {#DIV/0!,#DIV/0!,5,6,#DIV/0!,8,9,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0,!}. Why you say it returns the column if you divide?
Bro, thanks a lot!

 

[jasonb75]

The formula is dividing by the result of the <>0 criteria, not by the actual values in the cells. The next step of the array is COLUMN({3,4,5,6,7,8,9,10,11,12,13,14})/{FALSE,FALSE,FALSE,FALSE,TRUE,FALSE,TRUE,TRUE,FALSE,FALSE,FALSE,FALSE}

The index array is returning TRUE if there is a non zero number in the column or FALSE if it is zero.

For calculations, TRUE has a value of 1 and FALSE has a value of 0. Dividing the column numbers by an array of TRUE or FALSE leaves the column numbers for the columns with values, and errors for those without.

 

[tico_ocit]

The formula is dividing by the result of the <>0 criteria, not by the actual values in the cells. The next step of the array is COLUMN({3,4,5,6,7,8,9,10,11,12,13,14})/{FALSE,FALSE,FALSE,FALSE,TRUE,FALSE,TRUE,TRUE,FALSE,FALSE,FALSE,FALSE}

The index array is returning TRUE if there is a non zero number in the column or FALSE if it is zero.

For calculations, TRUE has a value of 1 and FALSE has a value of 0. Dividing the column numbers by an array of TRUE or FALSE leaves the column numbers for the columns with values, and errors for those without.

Thank you, nice and easy! Understood! Thank you so much for your help! Meanwhile, I have to ask help for another issue, Do Loop While!