View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shred77 shred77 is offline
external usenet poster
 
Posts: 9
Default Find the 10 lowest of 20 numbers in column and enter those 10 in a

Seeing all the Excel experts out here is giving me hope to solve this.
I am trying to find the 10 lowest (and if possible highlight them) of 20
numbers in a column and enter the results in the next column to the right.

There will be 6 columns total and 20 rows.
ADate BData Cdata Ddata Edata FData

The E Column is where I am looking to find the lowest 10 of 20 numbers
and the F Column is where I am looking to put those results.

Thank you in advance for any help you can give.

Dan


--
shredder