Forum Discussion
Solved
Dilema in Dynamic Array Filter Function With Merged Cells.
Hi, I am trying to update my personal sale information table using the new dynamic arrays formula where appropriate but just in my first attempt of trying to use the 'Filter Function', I hit a road...
ituryu Have a look at the attached (updated) workbook. It has a searchable dropdown for Lens Type. Type DUO and click the arrow and only lenses with DUO in the name are listed. Type BLUE and all the blue lenses come up. Is this something you can use?
See here for more.
As a comment, better not to merge the cells at all to avoid such and many other potential issues. For the majority of cases Center Across Selection works fine as substitution of cells merging.