I have an array formula in F4:F13 that generates a unique list from B17:B25 with criteria in B4 and criteriarange in D17:D25.
How to expand formula to include F17:F25 and H17:H25 in criteriarange ?
In the example file 876678 should also appear in the list.
TIA
Rudi
Bookmarks