Thread: What function to select the last 3 small values from a list ?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
juleeus
 
Posts: n/a
Default What function to select the last 3 small values from a list ?

A1:A9 is the range from where u want to select

=+IF(COUNT(A1:A9)=COUNT(A1:A9),CONCATENATE(SMALL(A 1:A9,1),",",SMALL(A1:A9,2),",",SMALL(A1:A9,3)),0)


--
juleeus
------------------------------------------------------------------------
juleeus's Profile: http://www.excelforum.com/member.php...o&userid=18356
View this thread: http://www.excelforum.com/showthread...hreadid=497096

Reply With QuoteReply With Quote