Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Now available on Stack Overflow for Teams! AI features where you work: search, IDE, and chat.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Let's say you want a range of cells beginning at D3, of height 3given in cell A1 and width 2, then:
=OFFSET(D3, 0, 0, 3A1, 2)
works.
Is there something even simpler than OFFSET, like RANGE(D3, 3A1, 2)?
OFFSET
RANGE(D3, 3A1, 2)
Let's say you want a range of cells beginning at D3, of height 3 and width 2, then:
=OFFSET(D3, 0, 0, 3, 2)
Is there something even simpler than OFFSET, like RANGE(D3, 3, 2)?
RANGE(D3, 3, 2)
Let's say you want a range of cells beginning at D3, of height given in cell A1 and width 2, then:
=OFFSET(D3, 0, 0, A1, 2)
Is there something even simpler than OFFSET, like RANGE(D3, A1, 2)?
RANGE(D3, A1, 2)