I have an XY table in excel. I would like to find the maximum Y value in a given X range. Example data given below. What equation can I use, in an unrelated cell, to output the max Y value in between the X range 2:6
| X | Y |
|---|---|
| 1 | 4 |
| 2 | 7 |
| 3 | 0 |
| 4 | 8 |
| 5 | 4 |
| 6 | 3 |
CodePudding user response：
Using MAXIFS:
=MAXIFS(B:B,A:A,">=2",A:A,"<=6")
As noted by @ScottCraner, if your version of Excel does not support MAXIFS, see 