You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:83ba7aadcab8c@uwe...
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