Gud day,
I have tried to use the ROW function of excel but it seems that the xcelsius doesn’t recognize the row function?? are there other ways to use the row function of excel in xcelsius??
thanks and regards,
ivan
jihmantiquilla 
(BOB member since 2010-07-06)
ROW() isn’t supported by Xcelsius. Type 1 in any cell, then type formulae something like =B2+1…Drag this till the point you can row number. Use this in xcelsius.
avbaby 
(BOB member since 2009-05-09)
wow! another filipino! hahaha!
use idex() and match() function. combine the 2. also, here’s a link that may help you: https://bobj-board.org/t/158169/3
mabuhay! hahahah!
R.A. (BOB member since 2008-10-28)
This works for me in Dashboard v6 build 14…
=COUNTIF($A$1:$A$10,"<>""")
Place it in a cell the same row as the last cell range (in the example would be row 10 but not in A10).
It seems to work for any datum type in the range including blanks and calculates correctly when rows are inserted or removed.
And most importantly no unsupported error when generating the flash!
lozeon (BOB member since 2009-10-09)