Reputation: 5001
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