Forum Discussion
felixspiers
Apr 19, 2022Copper Contributor
FINDING THE LOCATION OF A VALUE IN A LARGE DATA SET
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 wi...
HansVogelaar
Apr 19, 2022MVP
=MATCH(MAX(F:F),F:F,0) should return the row number of the cell with the max value in column F.