Quote:
Originally Posted by Purfleet
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?
|
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.