Ask Your Question
0

How to find the row with maximum value?

asked 2018-05-08 12:25:19 +0100

jondo gravatar image

I have got a column of numbers in Calc. How do I get the row number of the maximum?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2018-05-08 12:33:36 +0100

JohnSUN gravatar image

Just

=MATCH(MAX(<column>);<column>;0)

For example for column A it will be

=MATCH(MAX(A:A);A:A;0)

Note - this will be the number of the first line with this value (if you have several identical values, then the formula returns the first one)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-08 12:25:19 +0100

Seen: 309 times

Last updated: May 08