Dynamic Range
Hello, Is there a way to create a Dynamic Range for data that runs through Rows than in Columns? I found several ways to do this by columns however not by rows. Thanks, -- jlg5454 ------------------------------------------------------------------------ jlg5454's Profile: http://www.excelforum.com/member.php...o&userid=30201 View this thread: http://www.excelforum.com/showthread...hreadid=519802 |
Dynamic Range
For a column (column A)
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1) So for a row (row 10) OFFSET(Sheet1!$A$10,0,0,1,COUNTA(Sheet1!$10:$10)) Read Help to understand OFFSET best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "jlg5454" wrote in message ... Hello, Is there a way to create a Dynamic Range for data that runs through Rows than in Columns? I found several ways to do this by columns however not by rows. Thanks, -- jlg5454 ------------------------------------------------------------------------ jlg5454's Profile: http://www.excelforum.com/member.php...o&userid=30201 View this thread: http://www.excelforum.com/showthread...hreadid=519802 |
Dynamic Range
Works Great! Thanks -- jlg5454 ------------------------------------------------------------------------ jlg5454's Profile: http://www.excelforum.com/member.php...o&userid=30201 View this thread: http://www.excelforum.com/showthread...hreadid=519802 |
All times are GMT +1. The time now is 09:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com