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?