| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicate parts with non matching descriptions | Excel Discussion (Misc queries) | |||
| Choose highest value duplicate | Excel Worksheet Functions | |||
| How to locate duplicate data | Excel Discussion (Misc queries) | |||
| average of highest 48 of 52 radom numbers with duplicate low #'s | Excel Worksheet Functions | |||
| How do I locate duplicate records in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
