Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup is not enough !!
Hi there,
Please help me out with the folliwing query. This is my data which I wish to lookup: Group name 12 Brian 33 Norman 12 Victor 12 Sonia 25 Mary 33 Horris 25 Peter 44 james 66 Holden I wish to select say groups 12 & 33 and wish to obtain the following answer (i.e. list all under each other who belong to that group) Thereof 12 Brian 12 Victor 12 Sonia 33 Norman 33 Horris Is this possible ... I hope I made myself clear enough. If not, please reply and I will elaborate further. Thanks, Brian |
#2
|
|||
|
|||
Vlookup is not enough !!
This is an Autofilter job!
Data/Autofilter Click drop down arrow on column Group Choose equals 12 in first condition line Click option button OR Choose equals 33 in second condition line Optionally you should first sort your data by column Group. Regards, Stefi €˛Brian Ferris€¯ ezt Ć*rta: Hi there, Please help me out with the folliwing query. This is my data which I wish to lookup: Group name 12 Brian 33 Norman 12 Victor 12 Sonia 25 Mary 33 Horris 25 Peter 44 james 66 Holden I wish to select say groups 12 & 33 and wish to obtain the following answer (i.e. list all under each other who belong to that group) Thereof 12 Brian 12 Victor 12 Sonia 33 Norman 33 Horris Is this possible ... I hope I made myself clear enough. If not, please reply and I will elaborate further. Thanks, Brian |
#3
|
|||
|
|||
Vlookup is not enough !!
Hi Thanks for your answer ... however what i provided is only a simple
example of my data ... the nunmber of groups I have in fact exceeds 100 ! The autofilter can never apply !!! Any other suggestions ??? "Stefi" wrote: This is an Autofilter job! Data/Autofilter Click drop down arrow on column Group Choose equals 12 in first condition line Click option button OR Choose equals 33 in second condition line Optionally you should first sort your data by column Group. Regards, Stefi €˛Brian Ferris€¯ ezt Ć*rta: Hi there, Please help me out with the folliwing query. This is my data which I wish to lookup: Group name 12 Brian 33 Norman 12 Victor 12 Sonia 25 Mary 33 Horris 25 Peter 44 james 66 Holden I wish to select say groups 12 & 33 and wish to obtain the following answer (i.e. list all under each other who belong to that group) Thereof 12 Brian 12 Victor 12 Sonia 33 Norman 33 Horris Is this possible ... I hope I made myself clear enough. If not, please reply and I will elaborate further. Thanks, Brian |
#4
|
|||
|
|||
Vlookup is not enough !!
Hi Brian
Try using a Pivot Table. Mark your range of data (do not have a blank row below your headings). DataPivot TableNextNextFinish Drag Group to Row area, drag Name to Row Area drag Name to Data area Use the drop down on Group to select just the groups of interest. For more information on Pivot Tables take a look at http://peltiertech.com/Excel/Pivots/pivotstart.htm and http://www.contextures.com/xlPivot02.html Regards Roger Govier Brian Ferris wrote: Hi Thanks for your answer ... however what i provided is only a simple example of my data ... the nunmber of groups I have in fact exceeds 100 ! The autofilter can never apply !!! Any other suggestions ??? "Stefi" wrote: This is an Autofilter job! Data/Autofilter Click drop down arrow on column Group Choose equals 12 in first condition line Click option button OR Choose equals 33 in second condition line Optionally you should first sort your data by column Group. Regards, Stefi €˛Brian Ferris€¯ ezt Ć*rta: Hi there, Please help me out with the folliwing query. This is my data which I wish to lookup: Group name 12 Brian 33 Norman 12 Victor 12 Sonia 25 Mary 33 Horris 25 Peter 44 james 66 Holden I wish to select say groups 12 & 33 and wish to obtain the following answer (i.e. list all under each other who belong to that group) Thereof 12 Brian 12 Victor 12 Sonia 33 Norman 33 Horris Is this possible ... I hope I made myself clear enough. If not, please reply and I will elaborate further. Thanks, Brian |
#5
|
|||
|
|||
Vlookup is not enough !!
How many groups do you want to select at a time?
€˛Brian Ferris€¯ ezt Ć*rta: Hi Thanks for your answer ... however what i provided is only a simple example of my data ... the nunmber of groups I have in fact exceeds 100 ! The autofilter can never apply !!! Any other suggestions ??? "Stefi" wrote: This is an Autofilter job! Data/Autofilter Click drop down arrow on column Group Choose equals 12 in first condition line Click option button OR Choose equals 33 in second condition line Optionally you should first sort your data by column Group. Regards, Stefi €˛Brian Ferris€¯ ezt Ć*rta: Hi there, Please help me out with the folliwing query. This is my data which I wish to lookup: Group name 12 Brian 33 Norman 12 Victor 12 Sonia 25 Mary 33 Horris 25 Peter 44 james 66 Holden I wish to select say groups 12 & 33 and wish to obtain the following answer (i.e. list all under each other who belong to that group) Thereof 12 Brian 12 Victor 12 Sonia 33 Norman 33 Horris Is this possible ... I hope I made myself clear enough. If not, please reply and I will elaborate further. Thanks, Brian |
#6
|
|||
|
|||
Vlookup is not enough !!
Maybe using data|Filter|advanced filter would work:
http://contextures.com/xladvfilter02.html (Debra Dalgleish's site) I sometimes use another column that evaluates to true/false based on some criteria. Then filter on that: Maybe something like: =OR(A2={13,14,15}) Brian Ferris wrote: Hi there, Please help me out with the folliwing query. This is my data which I wish to lookup: Group name 12 Brian 33 Norman 12 Victor 12 Sonia 25 Mary 33 Horris 25 Peter 44 james 66 Holden I wish to select say groups 12 & 33 and wish to obtain the following answer (i.e. list all under each other who belong to that group) Thereof 12 Brian 12 Victor 12 Sonia 33 Norman 33 Horris Is this possible ... I hope I made myself clear enough. If not, please reply and I will elaborate further. Thanks, Brian -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |