OOOPS!

I gave you the wrong formula for A2: it should be

=IF(ROW(1:1)$A$1,"",SMALL(IF(Sheet1!$B$2:$B$1000= $B$1,ROW($2:$1000),""),ROW(1:1)))

enterd as array - Ctl+SHift+enter and dragged down.

It looked OK, but it wasn't. It should be OK now.

Sorry about that.

Declan O'R


--
DOR
------------------------------------------------------------------------
DOR's Profile: http://www.excelforum.com/member.php...o&userid=29088
View this thread: http://www.excelforum.com/showthread...hreadid=490341