Calc, define database range without empty cells? [closed]

asked 2016-01-17 22:14:55 +0200

LibreGuy gravatar image

Hi guys,

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

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


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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-28 22:27:59.516034


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

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

Chris UK gravatar imageChris UK ( 2016-01-17 22:29:38 +0200 )edit

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.

LibreGuy gravatar imageLibreGuy ( 2016-01-18 17:03:35 +0200 )edit