FINDING THE LOCATION OF A VALUE IN A LARGE DATA SET

New Contributor

I am working with a large data set (~8000 rows) and need to find the strain at the max stress value, i can find the max value using the =max() function but i cannot find the location of this value without manually scrolling down, if there is a function to find the row number of this value that would be great thanks. below is a photo that shows the start of my data setdata set.JPG

1 Reply

@felixspiers 

=MATCH(MAX(F:F),F:F,0) should return the row number of the cell with the max value in column F.