Skip to Content
0
Former Member
May 21, 2010 at 01:36 PM

Stumped on a Xcelsius Compatability Question

21 Views

Hi guys,

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.

Thanks...

Greg