Forum Discussion

ianshaw2's avatar
ianshaw2
Copper Contributor
Sep 24, 2022
Solved

Rows of numbers selection and addition

Hi There

I have a row of 20 to 30  different numbers and need to select the highest ten and total the result of the highest 10 at the start of the row.  I am not even sure if this can be done so any advice is very much appreciated.

2 Replies

    • ianshaw2's avatar
      ianshaw2
      Copper Contributor
      your are a bloody excel genius!!! - thank you so much for your help