complicated lookups?

[mrb13676]

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 cal
for the night.

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

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

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

Thanks
Mik

 

[Don Guillett]

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

How about just using data>filter>autofilter>filter on N column