Well everything could be better.
Nara it seems that the biggest slow down is from the formula you gave me in the other post
http://chandoo.org/forum/threads/co...olumns-sorted-and-compress.20089/#post-121224
Which is a good formula and no one else gave a better solution so that is the best solution.
Array Columns like for example Nov BM take the most and then K.
BM which has 10 things to calculate in a row out of 2100.
=IFERROR(INDEX($BK$2:$BK$2100,MATCH(SMALL(IF(LEFT($BE$2:$BE$2100,3)=$BM$1,IF($BK$2:$BK$2100<>"",$BL$2:$BL$2100+$BK$2:$BK$2100%%%)),ROW(BD1)),$BL$2:$BL$2100+$BK$2:$BK$2100%%%,0)),"")
and K
=IFERROR(INDEX($BI$2:$BI$2100,MATCH(SMALL(IF($BE$2:$BE$2100=$F$2,IF($BI$2:$BI$2100<>"",$BG$2:$BG$2100+$BI$2:$BI$2100%%%)),ROW(BD1)),$BG$2:$BG$2100+$BI$2:$BI$2100%%%,0)),"")
at least 2 billion calculations within the file alone.
And the next is the standard vlookup.
Also the fact that a "0" or error message of no result instead of a blank cells is not the default value when nothing is present can cause problems.
So if I take out the standards that is used a lot and a formula that no one else has a better solution to what is left is that excel can not handle it. Obviously I am annoyed since its been over a month and no one seems to have a solution to what I say and when I did find one it should not exist. LOL
Obviously it is over 100,000 of formulas a worksheet since one cell can consist of over 1 million formulas to be in a second, and that does not insult the amount to rows and columns it has to look throughout which is over 2,000 rows and at least 2 columns. which would be at least 4 billion a second. Core I5 can do over 40,000 MIPS so it should be enough but it's not. Maybe it's MIPS in binary which takes up most of the process? 0 1, 0 you 01 Obviously a silly assumption.
Well if excel can not handle it can a program dedicated to it handle it? Scheduling software companies say wow we can not handle that and its too advanced... for them. To say that a specific place to be place should be visited every x weeks too advanced. Funny its easy to do by hand but hard for a computer. Well so it seems with excel.
Warning Rant...
MS office 2000 in some ways do more than the latest version which is almost typical of MS devolution. I can copy and replace various complex formulas a second while this is limited in some ways or not as user friendly. Let alone windows search option which has gotten clunky/useless.
Well Microsoft has been making things worse over the years as if to stifle productivity to make things worse like the user interface to programs how they are inconsistant ands clunky, and even there flagship products like windows 8 being considered the worst OS of all time, the annoying ribbons in office. xbox one which they can not count to 3, but the next windows can not count to 9. But MS is known to not not go to standards or even be comparable to help with productivity which is one reason why most do not like designing for IE to let FF and Chrome lead and is only staying afloat due to people assumption that all are the same or the best is the one that comes with the PC.
Good things people like jeff has a book to sort it out in how unsure friendly things are. The notion of productivity went out the "Windows".
The funny thing is that besides the #1 things downloaded for Mac's is anti virus, the #2 is MS office, so that indicates how unresponsive and/or useless the other programs are.
Buy Jeff's book people, which MS site can not even explain how their programs work as clear as others since MS don't get it or know what they are doing.