Support Board
Date/Time: Mon, 14 Jul 2025 21:53:39 +0000
Post From: spreadsheet study question about using value as reference
| [2025-04-03 13:25:42] |
| Sawtooth - Posts: 4241 |
|
If I calculate a integer numerical value, is there a way I can reference that cell as the range amount for another cell?
This should work:=MIN(E3:OFFSET(E3,K3-3,0)) Or this, if K3 is absolute: =MIN(E3:OFFSET(E3,K$3-3,0)) |