I have a huge spreadsheet with lots of numbers and I have a cell using the =min(c:c)
This cell correctly returns the value of the minimum cell in column c, which is 7, but I need a way to find out where in column c what row) the cell with this value is located. I finally found it in cell c69 by using the find command and searching for the value 7, but I'm thinking there must be an easier way, some way for excel to return the source cell for which a function matches up. ctrl F2 doesn't seem to work. Any ideas how to do this? many thanks