Support Board
Date/Time: Wed, 30 Apr 2025 20:59:36 +0000
Post From: spreadsheet study question about using value as reference
| [2025-04-03 13:25:42] |
| Sawtooth - Posts: 4211 |
|
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)) |