View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Find Smallest and Largest.

You might try looking in the help index for SMALL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dlbeiler" wrote in message
...
I have a column of random numbers and need to find the smallest, second
smallest, third smallest, third largest, second largest, largest and
highlight these numbers with different font colors.