| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range that expand
Hi, I found in one of my Excel book this formula for expanding the range so I do not need adjust the chart range everytime I add a data. =OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1) The problem I have is tha this formula is good when a row is added. On one of my charts I have the following: Week 1 Week 2 Week 3 Etc.. Customer 1 5 3 1 Customer 2 6 0 6 Customer 3 0 3 2 Etc.. Every week I add another collumn. Is there a formula like above that can help me? Thank you. Juran -- Juran ------------------------------------------------------------------------ Juran's Profile: http://www.excelforum.com/member.php...o&userid=23592 View this thread: http://www.excelforum.com/showthread...hreadid=569250 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range that expand
=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,counta(sheet1!$1:$1))
(not sure if you wanted to subtract 1 from the count of columns, too???) See Debra Dalgeish's site for some nice tips: http://contextures.com/xlNames01.html#Dynamic Juran wrote: Hi, I found in one of my Excel book this formula for expanding the range so I do not need adjust the chart range everytime I add a data. =OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1) The problem I have is tha this formula is good when a row is added. On one of my charts I have the following: Week 1 Week 2 Week 3 Etc.. Customer 1 5 3 1 Customer 2 6 0 6 Customer 3 0 3 2 Etc.. Every week I add another collumn. Is there a formula like above that can help me? Thank you. Juran -- Juran ------------------------------------------------------------------------ Juran's Profile: http://www.excelforum.com/member.php...o&userid=23592 View this thread: http://www.excelforum.com/showthread...hreadid=569250 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to expand the autofilter range 1000 to 10000? | Excel Worksheet Functions | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
Hybrid Mode
