If Formula

[eramirez148]

How can I get the results in column C. If Column A is repeated then I want the largest value in column B to appear in Column C in the same row.

Column A	Column B	Column C
Product 1	10
Product 1	20
Product 1	30	30
Product 2	40	40
Product 2	20
Product 2	10
Product 3	10
Product 3	15
Product 3	60	60
Product 3	20
Product 3	5

 

[ExcelToDAX]

In Cell C1, how about:

=LET(maxVal,MAXIFS($B$1:$B$11,$A$1:$A$11,A1),IF(B1=maxVal,maxVal,""))