Thanks for the help!


"Max" wrote in message
...
The X's in col. B are the result of an IF
formula, something like =if(c32000,"X",""),

Oops, missed the significance of this part of your post earlier ..

If you currently have
in B1: =IF(C12000,"X",""), copied down

just change the formula
in B1 to : =IF(C12000,ROW(),"")
and copy down

The above formula replaces the previous
Put in C1: =IF(B1="x",ROW(),"")

Then in Sheet2,

Put in A1:


=IF(ISERROR(MATCH(SMALL(Sheet1!$B:$B,ROWS($A$1:A1) ),Sheet1!$B:$B,0)),"",INDE
X(Sheet1!A:A,MATCH(SMALL(Sheet1!$B:$B,ROWS($A$1:A1 )),Sheet1!$B:$B,0)))

and copy down, as before

(It's the same formula as previous, except pointing now
to Sheet1!$B:$B within the MATCH(SMALL(...)...) parts
instead of the previous Sheet1!$C:$C)

You'll get the desired results in col A
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----