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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATCH
Hi,
You could write a vba program to do it, but its not clear if each room is in a separate column or in one cell to the right of a service. This would also be an issue for a formula approach. You might want to look at a pivot table, then you could filter on service and show only the rooms for that service. Rooms in the column area and data area, Service in the row area. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "NICK" wrote: "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATC
Yes , but when you get into pivot tables I get lost. All the rooms are listed
in column A across 14 pages of floors. Devil is in the details. -- Thanks, Nick "Shane Devenshire" wrote: Hi, You could write a vba program to do it, but its not clear if each room is in a separate column or in one cell to the right of a service. This would also be an issue for a formula approach. You might want to look at a pivot table, then you could filter on service and show only the rooms for that service. Rooms in the column area and data area, Service in the row area. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "NICK" wrote: "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATC
Hi,
Check your other post "NICK" wrote: Yes , but when you get into pivot tables I get lost. All the rooms are listed in column A across 14 pages of floors. Devil is in the details. -- Thanks, Nick "Shane Devenshire" wrote: Hi, You could write a vba program to do it, but its not clear if each room is in a separate column or in one cell to the right of a service. This would also be an issue for a formula approach. You might want to look at a pivot table, then you could filter on service and show only the rooms for that service. Rooms in the column area and data area, Service in the row area. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "NICK" wrote: "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 |
Reply |
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 |