complicated lookups?
 

I have a smallish excel spreadsheet.
It is for an oncall roster.

In column A are the names of the individuals.
In column B is the letter "N" in the row of the people who are on call for the night.

How do I create a NEW list which has the names of those people who have the letter "N" next to their name?

Usually there are 35 odd names in column A and only 4-5 have "N" in column B.

Is this possible? Have looked at VLOOKUP and INDEX-MATCH but am having no joy.
Any help would be MUCH appreciated.

Thanks
Mike

complicated lookups?
 

On Wednesday, July 25, 2012 8:43:42 AM UTC-5, mrb13676 wrote:
I have a smallish excel spreadsheet.
It is for an oncall roster.

In column A are the names of the individuals.
In column B is the letter "N" in the row of the people who are on call
for the night.

How do I create a NEW list which has the names of those people who have
the letter "N" next to their name?

Usually there are 35 odd names in column A and only 4-5 have "N" in
column B.

Is this possible? Have looked at VLOOKUP and INDEX-MATCH but am having
no joy.
Any help would be MUCH appreciated.

Thanks
Mike




--
mrb13676

How about just using datafilterautofilterfilter on N column