Put the numbers in a range, and then just replace {12,33} with that range
reference.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian Ferris" wrote in message
...
Hi Bob ...

Thanks for your reply,

However the 12 & 33 was just an example, these group numbers will always
change and there will be more than 100 groups making it impossible to
enter
in the formula !!!

Is there some other way ???

Thanks in advance once again,
Brian


"Bob Phillips" wrote:

Brian,

Assuming that the data is in columns A & B, use these formulae


=IF(ISERROR(SMALL(IF($A1:$A20={12,33},ROW($A1:$A20 ),""),ROW($A1:$A20))),"",

INDEX(A1:A20,SMALL(IF($A1:$A20={12,33},ROW($A1:$A2 0),""),ROW($A1:$A20))))


=IF(ISERROR(SMALL(IF($A1:$A20={12,33},ROW($A1:$A20 ),""),ROW($A1:$A20))),"",

INDEX(B1:B20,SMALL(IF($A1:$A20={12,33},ROW($A1:$A2 0),""),ROW($A1:$A20))))

These are both array formulae, but you don't enter in just one cell at a
time, but a block. So, assuming your source data has 20 rows, select 20
rows
elsehwere on the spreadsheet, add the first formula to the formula bar,
and
commit with Ctrl-Shift-Enter, Then repeat in an adjacent column with the
second formula.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian Ferris" wrote in message
...
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