Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list query
Hi all,
Using MS Excel 2003, I have a table which includes a list of names down in column A, then across the top row is a group of 5 values (0-10,11-20,21-30 etc), the following row then has each of these lists split into 3 further groups within each of the above groups (0-12,13-24,-25-36 - these are for months). The rest of the table is filed with numbers which would be read against which name and group it fitted into. My query is: Is there a way that I can use drop down lists to select each of the outcomes from the table (eg the name, between 11-20 and then 12-24) and then they tell me the value of the cell which the would equal. I would like to know if there is a specific formula which can be used for this. Many thanks in advance. S |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list query
I don't think you can do this with drop downs but if you are willing
to modify your data layout, you can mimic what you describe below by using a pivot table. Try this: 1) transpose the months (0-12, 13-24...) from a column to a row 2) Select all the data, go to Data - Pivot Table and Pivot Chart (follow the steps to create a pivot) 3) Finally, add the name field as a row and the 2 column fields as columns and add the numbers you want to return to the data area. you can then use the drop downs in the pivot to filter the data as you describe below. On Jul 10, 2:50*pm, SD125 wrote: Hi all, Using MS Excel 2003, I have a table which includes a list of names down in column A, then across the top row is a group of 5 values (0-10,11-20,21-30 etc), the following row then has each of these lists split into 3 further groups within each of the above groups (0-12,13-24,-25-36 - these are for months). The rest of the table is filed with numbers which would be read against which name and group it fitted into. My query is: Is there a way that I can use drop down lists to select each of the outcomes from the table (eg the name, between 11-20 and then 12-24) and then they tell me the value of the cell which the would equal. I would like to know if there is a specific formula which can be used for this. Many thanks in advance. S |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list query
Thanks for the swift response Tim but I am unsure as to what you have
suggested, as I am fairly new to excel. I'll try to expalin the table I have a little better so that you can understand what it is I want: A3:A20 are name fields I have then merged then top cells B1:D1, E1:G1 etc with the 0-10,11-20 etc as mentioned below. B2,C2 and D2 then have 0-12, 13-24,25-36 respectively, this is then repeated in E2,F2,G2. The rest of the table the contains values which are what correspond to the name, value and month being picked. When just looking at the table this all looks pretty but I'm unsure what I would need to do next. What I want is somewhere else in the sheet to be able to select the three outcomes and it to then tell me which value in the table that corresponds to. Thanks again "Tim879" wrote: I don't think you can do this with drop downs but if you are willing to modify your data layout, you can mimic what you describe below by using a pivot table. Try this: 1) transpose the months (0-12, 13-24...) from a column to a row 2) Select all the data, go to Data - Pivot Table and Pivot Chart (follow the steps to create a pivot) 3) Finally, add the name field as a row and the 2 column fields as columns and add the numbers you want to return to the data area. you can then use the drop downs in the pivot to filter the data as you describe below. On Jul 10, 2:50 pm, SD125 wrote: Hi all, Using MS Excel 2003, I have a table which includes a list of names down in column A, then across the top row is a group of 5 values (0-10,11-20,21-30 etc), the following row then has each of these lists split into 3 further groups within each of the above groups (0-12,13-24,-25-36 - these are for months). The rest of the table is filed with numbers which would be read against which name and group it fitted into. My query is: Is there a way that I can use drop down lists to select each of the outcomes from the table (eg the name, between 11-20 and then 12-24) and then they tell me the value of the cell which the would equal. I would like to know if there is a specific formula which can be used for this. Many thanks in advance. S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |