| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I ignore blanks within my list without losing references?
I have a list that contains 2 columns. Column A is the group name and Column
B is the members of that group. Therefore, Column A is repeating for each entry in Column B. I would like to be able to leave the duplicate entries in Column A blank and just create a list (for use as validation on another sheet), omitting all the blanks. Is this possible? Ex: GROUP MEMBERS Admin John Sue Carol Users Joe Missy Amy Managers Robert Deborah I want to be able to have a validation list that contains Admin, Users, Managers without blanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore Blanks in Data Validation | Excel Worksheet Functions | |||
| Vetical Filling blanks in a list | Excel Discussion (Misc queries) | |||
| USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) | |||
| validation list blanks | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Threaded Mode
