@ Habanero
the IF(ISERROR(LOOKUP(...............),0,LOOKUP(2,1/((.......................)) hundreds of them i think,, is the culprit here..i just deleted all of this formulas and it is normal again..
jeffrey is right, a named ranged maybe!!????
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
See if this version improves the speed. I have added 3 named ranges, changed some formulas to use those ranges, removed the OFFSET functions and restricted the lookups to being used in one column only (new formulas in column A) and then the others use the row number returned in INDEX formulas. I also adjusted the summary table at the top to use SUMIF for the months.
Good luck.
This is huge help (and a good lesson). Much appreciated. I've loaded the data back in and it's looking good, and I'm understanding what you did. I'm going to go over the math and see how it compares to the original one and its data.Originally Posted by OnErrorGoto0
Everyone, y'all have been great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks