Forum Discussion
Second to last value from table with condition
I only use Excel, and that on a Surface laptop. For years I had held the view that, if you were primarily interested in shared development and multi-platform use, Google Sheets would be the software of choice whereas, if you were a single user with serious programming objectives, Excel would suit you better.
Now everything appears up for grabs. I was startled at how rapidly Google responded to the game changing LET and LAMBDA. Equally, many of the recent Microsoft changes have had multiplatform use and sharing at their core. My guess is that you have the options of downloading Excel for Android or modifying the code to use INDEX and ROWS, in place of TAKE to return the final values and continuing to use Sheets.
If you make either or both work, I would be interested to know!
