![]() |
|
#1
|
|||
|
|||
![]()
As long as the min is unique you can use =Match(min(C:C),C:C,0) to give you the row number.
However i would ask why you need to know the location of the Min number, is it for another formula? |
#2
|
||||
|
||||
![]()
Does your range start in row 1?
|
#3
|
|||
|
|||
![]()
Thanks, I tried this formula and it returned a value of row 69 so it appears to work, but I'm wondering what will happen if I have 2 cells in column c with a value of 7? The reason I need to know the row location of the min number is because my spreadsheet is a bunch of numerical values in column c that equate to a related date in column a. So I want to know what date my minimum value of 7 was achieved. your formula appears to achieve this, at least it does if the value 7 in column c is unique.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cloa513 | Word Tables | 13 | 09-19-2016 11:11 PM |
![]() |
markharper80 | Excel | 3 | 02-16-2015 04:18 PM |
![]() |
bharathkumarst | Excel | 7 | 10-13-2014 10:25 AM |
Can anyone here tweek this macro for renaming Excel files based on a cell's contents? | chrisd2000 | Excel Programming | 6 | 07-01-2014 01:53 PM |
![]() |
cglenn | Word Tables | 2 | 08-24-2011 07:04 AM |