Thread: SMALL function to find X smallest number greater than Y
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kittronald kittronald is offline
external usenet poster
  
Posts: 162
Default SMALL function to find smallest number greater than 0
Dave,

How can you get COUNTIF to use an array constant ?

For example, =COUNTIF(Names=$B2,"=0")



- Ronald K.
Reply With QuoteReply With Quote