Locate duplicate descriptions, remov and return highest barcode nu

  • Thread starter Thread starter Nikkynock
  • Start date Start date
N

Nikkynock

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
 
PLEASE IGNORE THIS QUERY - POSTED IN ERROR - SUBSEQUENT (CORRECT) POSTING FOR
THIS QUERY HAS BEEN MADE - THANKS
 
Back
Top