Calc, define database range without empty cells?

[LibreGuy]

Hi guys,

Is it possible to define a database range without empty cells?

For example if I define a database range “Categories” like this:

$Categories.$A$1:$A$500

Is it possible to define this range where it skips/ignores empty cells?
So something like this:

$Categories.$A$1:$A$500 WHERE cell is not empty

Can that be done?

[ChrisUK]

This might work, not going to answer with it as i dont know.

IF($Categories.$A$1:$A$500 !"", $Categories.$A$1:$A$500)

[LibreGuy]

Thanks for your reply Chris. I’ve tried it but it didn’t work. It said “Invalid range”.

Since no-one else has answered the question, I assume it’s not possible then.