Support Board

Date/Time: Sun, 28 Apr 2024 17:43:38 +0000

Post From: Spreadsheet Programing - MAX function question

[2021-11-30 03:55:08] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3980
either my software is broken or MAX wont accept it. What you want to do is possible. The examples prove it because they are doing the same thing. So it's just a matter of giving MAX what it needs. Whatever you're doing in BM3/BN3 might need to be rethought. MATCH gives INDEX the row so it can return its value, which when used with MAX becomes one side of its range. Repeat this for the other side of MAX's range. The key here is getting MATCH to give the correct offsets to INDEX. So start with just the MATCH and see if you can get it to give you what you need for INDEX. As for the MAX(...OFFSET(... combination example, giving it BM3 and BN3 might not be what it needs either.