You're welcome. Thanks for the feedback!
Biff
"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:6baf90837e08f@uwe...
Hi Biff,
Thank you very much. That certainly did the job. Great!
T. Valko wrote:
Array entered:
=IF(COLUMNS($A:A)<=COUNTIF($B17:$B100,"=4"),SMA LL(IF($B17:$B100=4,$A17:$A100),COLUMNS($A:A)),"")
Copy across.
Biff
--
Message posted via http://www.officekb.com