I have a long list of items. Each other line has text while each othr line is empty.
I want to use this as a data validation list and leave out the empty lines. What is my best option?
I have a long list of items. Each other line has text while each othr line is empty.
I want to use this as a data validation list and leave out the empty lines. What is my best option?
Use a helper column to load the data without blanks and refer it in DV range
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks