Avatar of macentrap
Flag for Australia

asked on 

Identify duplicates in a column then find the maximum value of adjacent column values in excel

Hello Experts

Based on duplicates in column A, I am trying to show the  highest value support identifier from values in column 'D'

in attached sample:
Column A : Request reference
Column B : Request task
Column C: Support group
Column D: Support group identifier
Column E: desired result
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon