TyForHelpDude
TyForHelpDude

Reputation: 5001

calculating max value ocurrance for each row formula in excel

A      B

1      4
2      5
3      6
100    7
1000   8

how can find number of max value of column values for each row. =COUNTIF(A1:B5,A1:A5) trying this but this gives 0. I expected 2.

Since; 100 and 1000 are the max values of their rows. need only max value times for rows for A

Upvotes: 0

Views: 34

Answers (1)

Piyush
Piyush

Reputation: 1162

This is one of the ways you can do it.

enter image description here

Should give you 2.

Upvotes: 0

Related Questions