Column1 | Column2 | Column3 | Custom | |
pear | 7 | pear | ||
pear | 3 | apple | ||
apple | 5 | |||
pear | 12 | |||
orange | 6 | |||
apple | 12 | |||
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
IF = Table.AddColumn(Source, "Custom", each if [Column3] = List.Max(Source[Column3]) then [Column1] else null),
FilterNull = Table.SelectRows(IF, each ([Custom] <> null)),
TSC = Table.SelectColumns(FilterNull,{"Custom"})
in
TSC
Thank you=INDEX($A$5:$A$16,MATCH(MAX($C$5:$C$16),$C$5:$C$16,0))