I would like to make a boolean on every row in a list that tells me if that row is hidden by a filter or not.
(Want to use that for several sumproduct formula's)

Can that be done a formula or would I need VBA?

Thanks for your help.
Arien