Maybe

=SMALL($E$1:$E$20,ROW(A1))

Put this in F where you want the result and drag down 10 rows.

Mike

"shred77" wrote:

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