Hi Bec,

Or do you mean 'each' players 3 lowest scores.
In which case this might help,

Using your example data in A1:G3
In say J1 put this formula
=SMALL($B1:$G1,COLUMN()-9)
Then drag across to L1
Then drag all three cells down to row 3

If you were to start in say M1 the formula would be
=SMALL($B1:$G1,COLUMN()-12)
Then drag across to O1
Then drag all three cells down to row 3

HTH
Martin


"AussieBec" wrote in message
...
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