Comment on $16bn health agency managed finances with Excel spreadsheet.

• nimble@lemmy.blahaj.zone ⁨3⁩ ⁨weeks⁩ ago

  Would you like this in excel formula, VBA, or python?

  It can be done in all. You’re only proving the other poster’s point. Excel isn’t necessarily the best option for tech literate people but given the tech illiteracy of many offices, it isn’t surprising they use excel for stuff like this.

  source
• silverhand@reddthat.com ⁨3⁩ ⁨weeks⁩ ago

  Anybody who used ANY library to process xslx knows MS keeps changing it :-)

  I highly doubt that, also, people in corporate finance do not use libraries to process excel files.

  About ranges… can you give me the range for whole columns minus 6 first records and 9 last records?

  =OFFSET(range_name, 7, COLUMNS(range_name), ROWS(range_name)-9) where range_name is the label given to the whole table.

  source