Hi Oxa,
Can you please advise how "sel_index-1" works:
horse_sheet!A(my_sidx+sel_index-1)
I figured out that "sel_index-1" identifies the number of runners in a market and writes to Excel one line per runner. But "-1" also subtracts value 1 from the value in the formula.
Above formula would not work like that: horse_sheet!A(my_sidx+sel_index-1), right?
Can you please explain the logic of "sel_index-1". In custom cells we can work with "sel_ind ex*3+1" for example.
The whole write to excel trigger is hard to understand without knowing how sel_index-1 works.
Are there more expressions using sel_index with special functions?
Cheers,
bamthwok