Forum Discussion

Twifoo's avatar
Twifoo
Silver Contributor
Feb 08, 2021

FIFO Inventory Formula Challenge

To revel my second anniversary as a member of this EXCELlent Community, I hereby proffer this challenge to season your array manipulation skills. Perhaps, keenadvice mathetes Riny_van_Eekelen PeterBa...
Formulas and Functions
rpbenz's avatar
rpbenz
Copper Contributor
Feb 20, 2021
Newer versions than 1907 Excel, calculation is broken. xlcalculationAutomatic will take over 50times longer in new versions (2012 and 2101) than early versions. Its totally screwed up.
  • mathetes's avatar
    mathetes
    Silver Contributor
    Feb 21, 2021

    rpbenz  wrote: Newer versions than 1907 Excel, calculation is broken

     

    I know Excel has been around for a while, but had no idea it went back that far. It's older than I am, and I've been retired since 2002.   😉

    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Feb 21, 2021

      mathetes 

      Microsoft messed the terms. If former time there were Office 95,...,2010, 2013,... etc and we called these as versions, now it's Office/Microsoft 365 and versions are actually branches (my understanding) within it. Currently from 1908 on one of semi-annual channels to 2013 on beta. Yes, there are such Excel editions as Excel 2019 and recently announced Excel 2021, not sure about versioning in them.

       

      As for the performance - can't comment, no stats and nothing concrete is here. In general after the year 2018 fall performance is only improving. 

Resources