@ron2k_1, goes without saying you should be looking to avoid double evaluation of any Array.
For the text strings D22 onwards simply encase the INDEX within a REPT call
Note: here there's no need to bother with the pre-emptive COUNTIF we can simply use contents of adjacent cell as our test (which has already conducted this test)
Regards your unique list... you needn't worry about double evaluation here given you can restrict your DNR to ignore the #N/A
Modify Data Validation source for C19 from the INDIRECT to:
there is no need for UniqueValidationList nor do you need the formula in J2
Bookmarks