I have numerous rows on sheet1 which can all contain up to 23 different values. I am using this formula which identifies and sums the best 14 values
Using conditional format I can also highlight those values.
Is there a way I can take those 14 values, using code, to a new row on Sheet 2 - thereby having only the highest values recorded on sheet 2.?
Thank you for looking.