oprsteny.com
Excel – Ignore blanks and duplicates in Validation list
I faced a problem where I had a worksheet where in column A there were items I wanted to use as source for validation list in another column. But these items were not unique, therefore they appeare…