What function to automatically select a few people from a list of names?

**CClio333** · 06-28-2017, 08:27 AM

I get reports from my company that I need to filter for the people who I manage as well as those managed by others but are helping out in my department. The only way for me to do this is by filtering the name column and selecting the eight or so people I care about out of the 50+ on the report. I get these reports quite frequently and I would love to have a way of automating this, but I'm not sure what the best method would be. Is there a way to tell Excel "highlight yellow everyone on this Tab 2 list" and then I could just filter for yellow?

**PFDave** · 06-28-2017, 08:32 AM

Yes you can, you would set that in conditional formatting.

Or you could add a helper column into your orginal table which will lookup the name in the list and tell you who they report to, then you could filter by your direct reports in the same way.

If you have an example workbook I can apply both solutions to it and you can see which you prefer.

What function to automatically select a few people from a list of names?

LinkBack

Thread Tools

Rate This Thread

Display

What function to automatically select a few people from a list of names?

Re: What function to automatically select a few people from a list of names?

Thread Information

Users Browsing this Thread

Similar Threads

Need formula to select 20 names from list of 300 with no repeats

Automatically select the most latest File Name from similar names ending with dates

[SOLVED] Search a list of names and automatically return any names not already included in table

select names from a list with criteria

Can i select multiple names from a list

Macro to select Names from dropdown list?

[SOLVED] i want to only select one name from a list of the same names

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions