Hi - I think these are the functions I need!
I have a list of names in sheet1 column A, some of which appear more than once. In column B I have a version number. I want to create a formula on another sheet that looks for a specific name, matches it on the other sheet and then finds the highest version number for that particular name.
PS the names are not sorted alphabetically so I can't use any Vlookups.
Eg-
Sheet1
Col A Col B
Apple 1
Pear 1
Orange 1
Apple 2
Banana 1
Sheet2
ColA Col B (Latest version number)
Apple 2
Pear 1
Orange 1
Banana 1
Any help much appreciated
Andyman
I have a list of names in sheet1 column A, some of which appear more than once. In column B I have a version number. I want to create a formula on another sheet that looks for a specific name, matches it on the other sheet and then finds the highest version number for that particular name.
PS the names are not sorted alphabetically so I can't use any Vlookups.
Eg-
Sheet1
Col A Col B
Apple 1
Pear 1
Orange 1
Apple 2
Banana 1
Sheet2
ColA Col B (Latest version number)
Apple 2
Pear 1
Orange 1
Banana 1
Any help much appreciated
Andyman