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
----
|