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