I need to make sure for every duplicate in column R, values in column U & columns AA through CU are the same. Condition being for column U the value that gets copied needs to be a number and not the text "NA" and if there is no number then it should be left alone . Whereas for column AA through CU the values that get copied should be for the row with latest year in AA (eg: 2020-2021) and the if the only value there is "NA" then it should be left alone. The header is in row 6 and the data starts on 7. If anyone could help me out with this I would be really grateful. Thanks in advance.