List of items appeared in range
I forgot:
I can't use advanced filtering option. It must be a formula (array). This
list will be used as part of form controlled by macros so Pivot Tables or
anything what requires refreshing and takes time can't be used.
|