Finding value of column y at max value of column X
I want to find the maxium value in column "Power (dBm)" grouped by BarID, ChipID.And use that to find the corresponding value in column "Wavelength (nm)" to give me a summary table showing the value of maxium power and what value of wavelngth it occurs at grouped by BarID, ChipID etc.