How do you find the row number of the minimum value of a range of cells (N8:N15)? I've tried =ROW(MIN(N8:N15)) however this does not seem to work.
by 
Anonymous
ANSWERS: 1
-
Let's say that your range of values is in cells A1:A25, then: =MATCH( MIN( A1:A25), A1:A25, 0) Now, if your range is in a row that doesn't start at 1, you need to account for that by adding the right number of rows to the MATCH value. So if your range of values is A26:A50, then: =MATCH( MIN( A26:A50), A26:A50, 0) + ROWS( $A$1:A26) - 1 I used that formula in case your range of values moves. As you add or delete rows between A1:A26, the formula also changes accordingly.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC