Support Board
Date/Time: Fri, 18 Apr 2025 05:50:39 +0000
Post From: spreadsheet study question about using value as reference
| [2025-04-03 13:25:42] |
| Sawtooth - Posts: 4205 |
|
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)) |