Forum Discussion
How to create a table that looks for a min and max value.
Hello all, I know basic Excel, but this is way beyond my knowledge. I have a table like this: Test Case | IDExecution | IDCSVRow | IDName | Value 8.4.2.1 0 0 Delay limit 802 8.4.2.1...
This formula is in cell F26 in the attached example:
=INDEX(E2:E21,MATCH(1,(B2:B21=D24)*(D2:D21=C28)*(E2:E21=F28),0)-2)This formula is in cell F27 in the attached example:
=INDEX(E2:E21,MATCH(1,(B2:B21=D24)*(D2:D21=C28)*(E2:E21=F28),0)-1)In cells G26 and G27 in the above formulas F28 is replaced by G28.
This formula is in cell F28 in the attached example:
=LARGE(IF((B2:B21=D24)*(D2:D21=C28),E2:E21),1)In cell G28 in the above formula LARGE is replaced by SMALL.
Enter the formulas with ctrl+shift+enter if you don't work with Office365 or 2021.
Hello, I tried to adjust your formula to my current spreadsheet, but i get error messages. I tried to attach the xml file, but it wont allow it,
So i took screenshots.
This is is for R6.
My rows go from 2 to 133.
This is for R7
and this is for R8
Thank you again!
Andres M.
Please see attached file.