I'm trying to find an Xcelsius compatible function to find the first non-blank cell in a column. The reason I am stumped is because I was able to write a function that worked perfectly in Excel and only uses functions supported by Xcelsius.
Can anybody help me out? Here is the function I have written:
=MATCH(TRUE(), INDEX(Data!K2:K200 <-> "", 0, 0), 0) + 1
(I added a dash between the < and > otherwise the forum ignores it)
Xcelsius gives me a %N/A when I "Preview" my dashboard.