Hi,

I am looking to remove duplicates of a descriptor in column a, and return
the highest value associaed with that descriptor in column b. For example:

column a column b
generic product 1 123456
generic product 1 789101
generic product 1 112131

returns:
generic product 1 112131

and removes all other lines of the same descriptor

many thanks for your help