Calc, define database range without empty cells?

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:

$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?

edit retag flag offensive close merge delete

Comments

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