Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding multiple items from a list
Hello all,
Wonder if you kind souls can help me out with this one. The office mangers in my territory need to complete some information for me and I'm trying to make that operation as easy as possible. One of which is automatically populating a particular sheet with their office staff details from another sheet containing details of all the staff in the company. If the data layout is similar to below; Office no OfficeName Forename Surname 4 Manchester Name Name 4 Manchester Name Name 4 Manchester Name Name 5 Leeds Name Name 5 Leeds Name Name How can I bring across multiple lines and use a formula so when the office manager at Manchester for example inputs a '4' in A1 the names of only his staff appear underneath. I use Index/Match regularly without problems but now I'm stumped as it's dealing with multiple lines or info. Many thanks for any advice, Colin. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding multiple items from a list
Will the data *always* be sorted or grouped by the office number as is shown
in your sample data? -- Biff Microsoft Excel MVP "Col" wrote in message ... Hello all, Wonder if you kind souls can help me out with this one. The office mangers in my territory need to complete some information for me and I'm trying to make that operation as easy as possible. One of which is automatically populating a particular sheet with their office staff details from another sheet containing details of all the staff in the company. If the data layout is similar to below; Office no OfficeName Forename Surname 4 Manchester Name Name 4 Manchester Name Name 4 Manchester Name Name 5 Leeds Name Name 5 Leeds Name Name How can I bring across multiple lines and use a formula so when the office manager at Manchester for example inputs a '4' in A1 the names of only his staff appear underneath. I use Index/Match regularly without problems but now I'm stumped as it's dealing with multiple lines or info. Many thanks for any advice, Colin. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding multiple items from a list
Hi,
You may want to try my solution posted at; http://office.microsoft.com/en-us/ex...260381033.aspx -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Col" wrote in message ... Hello all, Wonder if you kind souls can help me out with this one. The office mangers in my territory need to complete some information for me and I'm trying to make that operation as easy as possible. One of which is automatically populating a particular sheet with their office staff details from another sheet containing details of all the staff in the company. If the data layout is similar to below; Office no OfficeName Forename Surname 4 Manchester Name Name 4 Manchester Name Name 4 Manchester Name Name 5 Leeds Name Name 5 Leeds Name Name How can I bring across multiple lines and use a formula so when the office manager at Manchester for example inputs a '4' in A1 the names of only his staff appear underneath. I use Index/Match regularly without problems but now I'm stumped as it's dealing with multiple lines or info. Many thanks for any advice, Colin. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding multiple items from a list
Indeed, thank you very much.
I did actaully solve it by writing a very long formula compirisng CELL/MID/INDEX/MATCH/INDIRECT but yours is much better. Thank you. Colin. "Ashish Mathur" wrote in message ... Hi, You may want to try my solution posted at; http://office.microsoft.com/en-us/ex...260381033.aspx -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Col" wrote in message ... Hello all, Wonder if you kind souls can help me out with this one. The office mangers in my territory need to complete some information for me and I'm trying to make that operation as easy as possible. One of which is automatically populating a particular sheet with their office staff details from another sheet containing details of all the staff in the company. If the data layout is similar to below; Office no OfficeName Forename Surname 4 Manchester Name Name 4 Manchester Name Name 4 Manchester Name Name 5 Leeds Name Name 5 Leeds Name Name How can I bring across multiple lines and use a formula so when the office manager at Manchester for example inputs a '4' in A1 the names of only his staff appear underneath. I use Index/Match regularly without problems but now I'm stumped as it's dealing with multiple lines or info. Many thanks for any advice, Colin. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding multiple items from a list
Thank you for the feedback
-- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Col" wrote in message ... Indeed, thank you very much. I did actaully solve it by writing a very long formula compirisng CELL/MID/INDEX/MATCH/INDIRECT but yours is much better. Thank you. Colin. "Ashish Mathur" wrote in message ... Hi, You may want to try my solution posted at; http://office.microsoft.com/en-us/ex...260381033.aspx -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Col" wrote in message ... Hello all, Wonder if you kind souls can help me out with this one. The office mangers in my territory need to complete some information for me and I'm trying to make that operation as easy as possible. One of which is automatically populating a particular sheet with their office staff details from another sheet containing details of all the staff in the company. If the data layout is similar to below; Office no OfficeName Forename Surname 4 Manchester Name Name 4 Manchester Name Name 4 Manchester Name Name 5 Leeds Name Name 5 Leeds Name Name How can I bring across multiple lines and use a formula so when the office manager at Manchester for example inputs a '4' in A1 the names of only his staff appear underneath. I use Index/Match regularly without problems but now I'm stumped as it's dealing with multiple lines or info. Many thanks for any advice, Colin. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List - Select Multiple Items | Excel Worksheet Functions | |||
Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
Selecting multiple items from a drop down list | Excel Discussion (Misc queries) | |||
Want Vlookup to list multiple items with the same key? | Excel Worksheet Functions | |||
How to obtain Averages from a list of multiple items? | Excel Discussion (Misc queries) |