Apr 19 2022 01:21 PM
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 set
Apr 19 2022 01:23 PM
=MATCH(MAX(F:F),F:F,0) should return the row number of the cell with the max value in column F.