The attached file in sheet named 'CurrentGame2' I would like to update the "Better ERA" section using data from the sheet to the left of it.
For instance, V6:W6 should contain data from the team that has an ERA of -1 or greater comparing data in cells E8 and M8 (i.e. the first two teams). The cells have been manually filled in to show the desired results.
The formula should be able to be copied down.
Please note that when the numbers in E8 and M8 do not differ by one or greater then it is left blank. (i.e. V8:W11)