Support Board

Date/Time: Fri, 03 May 2024 08:35:31 +0000

Post From: New Spreadsheets INDEX function

[2014-11-23 03:56:35] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3992
Yes, I am used to doing things a certain way, which happens to be the same way the rest of the world uses Excel-compatible spreadsheets. Now I must reinvent the wheel, re-engineering things that are not directly convertible. As I do some reconfiguring, I'm finding other issues, for which I will start individual threads. I just recently discovered that I can use OFFSET to find a moving range as I formerly did with INDEX, so those have been resolved. But please fix INDEX so that it will accept a Row input other than 1, and one from a cell reference, and one from another function. Once INDEX is fixed, will I be able to do this?: MAX(INDEX(MATCH)):INDEX(MATCH))) where I define the range of MAX using a pair of INDEX(MATCH)).