CODEWITHSUNDEEP
excel-formulanamed-ranges
MRB
MRB

Reputation: 452

Excel formula with named range

I have a question about formulas, it´s not an easy one, I hope someone can solve it.

Table looks like this

Idx Val Rslt
1   1   3
1   2   3
1   3   3
2   11  13
2   12  13
2   13  13

Named range NR encapsulates columns Idx and Val (without headers).

I would like to have a formula for Rslt column cells that :

a) recognizes rows with same Idx value

b) returns max Val from that set of rows

I hope I was clear, if not - feel free to ask.

Thanks

Upvotes: 0

Views: 239

Answers (1)

Nick
Nick

Reputation: 36

=MAX(IF($A$2:$A$7=A2,$B$2:$B$7))

Type this in to C2 and then press ctrl+shift+enter, it will then fill the formula down.

Upvotes: 2

Related Questions