dynamic range HORIZTONALLY

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
420
i know veritfically (ie offset($a$1,0,0,counta(....)


but how do you make one horizontally for 2 rows.



also, is it possible to make a dynamic range formula that expands BOTH veritically and horizontally?
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
If you know Offset ... you are all set ...

Offset(ref,0,0, nbRows,nbColumns)
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
You can test

=OFFSET(Sheet1!$A$1,0,0,2,COUNTA(Sheet1!$1:$1))

Hope this will help
 

Watch MrExcel Video

Forum statistics

Threads
1,090,473
Messages
5,414,741
Members
403,543
Latest member
Phx007

This Week's Hot Topics

Top