Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookups | Excel Discussion (Misc queries) | |||
Lookups or something | Excel Worksheet Functions | |||
Help on lookups | Excel Discussion (Misc queries) | |||
Lookups | Excel Programming | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |