| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help list rooms by service owner
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 | |||
| how do I set the Owner in a spreadsheet | Excel Discussion (Misc queries) | |||
| counting the number of rooms | Excel Worksheet Functions | |||
| how can I check the current owner of the file stored in a common D | Excel Discussion (Misc queries) | |||
| rooms checklist | Excel Worksheet Functions | |||
| a simple way to set up spreadsheet for conference rooms reservatio | New Users to Excel | |||
Threaded Mode
