Hi Max ...

Thanks for your suggestion ... I am not sure whether I am asking too much ;)
... is it possible to send me a sample file with the below ...I would very
much appreciate it. My e-mail address is

Thanks in advance for your support,
Brian


"Max" wrote:

"Brian Ferris" wrote:
... Is there some other way ???

Another play to try using non-array formulas ..

Assume source data is in Sheet1, cols A & B, data from row2 down

Using 2 empty cols to the right, cols C and D

List the numbers in D1 down: 12, 33 (numbers can be listed in any order)

Put in C2:
=IF(ISNUMBER(MATCH(A2,D:D,0)),A2+ROW()/10^10,"")

Copy C2 down to say, C100, to cover the max expected data in cols A & B

(Leave C1 empty)

In Sheet2
-----
Put in A2:
=IF(ISERROR(SMALL(Sheet1!$C:$C,ROWS($A$1:A1))),"",
INDEX(Sheet1!A:A,MATCH(
SMALL(Sheet1!$C:$C,ROWS($A$1:A1)),Sheet1!$C:$C,0)) )

Copy A2 across to B2, fill down to B100
(cover the same extent as was done in col C in Sheet1)

Sheet2 will return the desired results from Sheet1 in cols A & B,
all neatly bunched at the top
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--