Support Board
Date/Time: Sun, 22 Dec 2024 06:06:13 +0000
Post From: New Spreadsheets INDEX function
| [2014-11-23 03:56:35] |
| Sawtooth - Posts: 4141 |
|
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)). |