I have a workbook that has over 25,000 contacts that includes Name - Email - Phone Number - Location - City - Role.
I am currently using a indirect list validation to sort between Location - City - However Roles are not filtered by City - they are filtered by location...
This leaves roles that aren't valid for the city...
How can I add something to include the City and not Location. Without creating named ranges?
I am currently using a indirect list validation to sort between Location - City - However Roles are not filtered by City - they are filtered by location...
This leaves roles that aren't valid for the city...
How can I add something to include the City and not Location. Without creating named ranges?