Locate duplicate descriptions, remov and return highest barcode nu
 

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

Locate duplicate descriptions, remov and return highest barcode nu
 

PLEASE IGNORE THIS QUERY - POSTED IN ERROR - SUBSEQUENT (CORRECT) POSTING FOR
THIS QUERY HAS BEEN MADE - THANKS

"Nikkynock" wrote:

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