Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATCH
"NICK" wrote:
I need to produce a list by sevice owner(column b) that will print all the rooms(column a) that fall under each service. please see below i.e. Service EMS 10002A,1002B,10010A....... Psychiatry 10002,10009, 10010, 10014........ ROOM SERVICE OWNER SECT 10002 PSYCHIATRY NURSING STATION 10002A EMS TOILET 10002B EMS TOILET 10009 PSYCHIATRY DINING RM 10010 PSYCHIATRY BREAK RM 10010A EMS TOILET 10014 PSYCHIATRY GROUP RM 10101 PSYCHIATRY LOCKER RM 10020 PSYCHIATRY GROUP RM 10020A RECREATION STORAGE 10100 PSYCHIATRY MUSIC RM 10101 PSYCHIATRY LOCKER RM 10102 PSYCHIATRY CONFERENCE RM 10103 PSYCHIATRY GROUP RM 10104 PRIMARY CARE/NURISNG OFFICE 10105 PSYCHIATRY TESTING ROOM 10106 REHAB RESTORATIVE CARE SERVICE STORAGE 10107 ENGINEER CLOSET TELEPHONE 10108 EMS STAIRS -- Thanks, Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match or identify if a product is in a list | Excel Discussion (Misc queries) | |||
Match values and create a list in one cell | Excel Discussion (Misc queries) | |||
Compare product prices from two supliers and produce report | Excel Worksheet Functions | |||
Product list to match price list | Excel Discussion (Misc queries) | |||
produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions |