Hi, Claus, thank you for your response. I tried your formula with one small modification: I changed ROW(A1) to ROW($A$1) and copied it down and it works great. :) Thank you so much!



try:

=INDEX($A$1:$A$100,SMALL(IF(B$1:G$100="Apples",ROW ($1:$100)),ROW(A1)))

and enter the array formula with CTRL+Shift+Enter

and copy down till you get an error



Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2