Support Board

Date/Time: Sun, 28 Apr 2024 06:36:46 +0000

Post From: Spreadsheet Programing - MAX function question

[2021-11-29 23:23:13] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3980
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))