On excel, I've two tabs: one listing all people participating to an event, with a lot of details. I've a "FullName" column which is basically defined by:
This column is named "FullName"(Original ;) )
In the other tab, I want to put the planning of the people and being able to select the person here, based on the previously mentionned column.
I tried to create a dynamic named range, but the issue is that the list of people could be like:
"FullName one" "Fullname two" " " "Fullname four"
and with all solution I currently found, they don't take in account that " " should be considered as blank for my case, and that maybe there is an empty cell, then a non-empty cell.
How would you handle this? I guess that dynamic named range are the good approach, but what formula?