Support Board
Date/Time: Thu, 26 Jun 2025 09:19:08 +0000
Post From: Spreadsheet Programing - MAX function question
| [2021-11-29 23:23:13] |
| Sawtooth - Posts: 4231 |
|
Have a look at this example, using the MAX(INDEX...MATCH...):INDEX(...MATCH...)) function combination: https://www.sawtoothtrade.com/example-10.html Here's another example. Look in cell S3 in the pic: https://www.sawtoothtrade.com/free-stuff-3.html You might also be able to use a modification of this example: =MAX(OFFSET(C3,BM3-1,0):OFFSET(C3,BN3-1,0)) |