I could not find an answer to my question by search.
Example:
I have four unsorted data ranges in Column B in the attached file, "Project1", "Project2", "Project3", "Project4"
I want to create an unsorted Array in Column D, ignoring spaces and #N/A in Column B
Bookmarks