View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Return Numeric Labels that have Values =4 across Single Row

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