Support Board
Date/Time: Mon, 23 Dec 2024 02:14:06 +0000
Post From: Index and Match on spreadsheet
[2015-01-01 13:12:54] |
heavyhucks - Posts: 18 |
=INDEX(O4:O36,MATCH(TRUE,INDEX((O4:O36<>""),0),0)) This is the formula that I have entered in the Sierra chart spreadsheet to index the next cell in a row that is not blank. It works perfectly in excel but returns #N/A in Sierra's spreadsheet. I have also tried putting 0's in the column instead of "" and matching cells that are larger than 0 but it still didn't work. Any ideas? |