Dear T. Valko,
Many thanks! It works extremely well!
Thanks,
Wilchong



T. Valko wrote:
You can use the same formula just change:

=0 to 0 (in 2 places)

=IF(ROWS(C$3:C3)<=SUM(--(COUNTIF(rng2,rng1)0)),INDEX(rng1,SMALL(IF(COUNTI F(rng2,rng1)0,ROW(rng1)-MIN(ROW(rng1))+1),ROWS(C$3:C3))),"")

Don't forget: array entered!

Dear T. Valko,
Really thank for your help. I am thinking how to revise the existing Excel
[quoted text clipped - 29 lines]
Many thanks,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200805/1