Hi y'all,

How do I write a formula that chooses only the cells with data in them? I know you can use =count() to return the number of cells with data, but is there a way to choose the whole array? The number of data points in each array also varies, so the formula would have to be flexible in that way.

Thanks,

Alex