cancel
Showing results for 
Search instead for 
Did you mean: 

Stumped on a Xcelsius Compatability Question

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Greg

The likely reason is that yo are trying to perform an array function within the INDEX() function (Data!K2:K200 <> "").

The best way around this is to have a simple column to check the values in column K, so maybe in column J do, =IF(K2="",1,0) and copy this down. Then your Match is a simple one, find the first 1 value down column J

Regards

Charles

Answers (0)