Thread: SMALL function to find X smallest number greater than Y
View Single Post
  #6   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
*** CORRECTION ***

The formula should read:

=IF(COUNTIF(Names,$B2)=1,"",IF(SUMPRODUCT(SMALL(IN DEX(Names=
$B2,)*INDEX(LEFT(Codes,LEN($A2))=$A2,)*INDEX(LEN(C odes),),
1))0,"","Duplicate"))


- Ronald K.
Reply With QuoteReply With Quote