With your data in (Say) A1:F3 put this in H1 and drag down 3 rows to get the
3 smallets values

=small(A1:F3,Row())

Mike

"AussieBec" wrote:

John 77 69 73 78 62 69
George 68 73 81 87 89 73
Len 84 77 75 65 87 77

Hi All

With figures above how do I calculate the lowest 3 scores without having to
sort each row? Your assistance is greatly appreciated, i can't wait to try a
suggestion tomorrow at work!!

AussieBec