How can I get Google Sheets to automatically check for 10 rep sets then of all those instances look at the weight and find the highest weight?

Like the title says I’d like to have a command to check all the entries for set numbers then if there is a set with 10 or more reps have it look to the weight number and then of all the weights it finds put the greatest weight in the cell to the right of 10 rep max

Showing the area I would like it too look for 10 sets or more