Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, Offset & Dymanic Name help
I have a spreadsheet that I will be updating monthly. Worksheet #1, I have
the columns monthly (Jan'08,Feb'08,Mar.....Feb'10) and 11 rows that contains data (north,south¦) for different entities. Further down the spreadsheet, the data is summed together. Worksheet#2 consists of a table containing 12 months of data and a line graph that is fed from Worksheet#1. Id like to be able to enter the new data and have the table take the last column on the right that contains data for the last month say Feb 09 update the table (last column) for month and ignore the remaining columns (Mar 09¦.Feb 10) until that data is available. In this example the columns(Mar 09¦.Feb 10) sum to zero. Im not sure if I should use, lookup, offset or a dynamic range name. Also, when I tried to using the lookup function, my last column contained zeros(Feb 09) and the lookup went to the month prior(Jan 09) giving me the incorrect total for the month of Feb. 09. Please help. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup, Offset & Dymanic Name help
Hi,
I'm not following your question you say you want to "Id like to be able to enter the new data and have the table take the last column on the right that contains data for the last month say Feb 09 update the table" So you want the table to update the table? Excluding this confusion, you probably need a dynamic range name if this table is layed out horizontally. Best would be if you told us the version of Excel and showed us a sample of the data layout. Generally dynamic range names use something like: =OFFSET($A$1,,,,COUNTA($A$1:$M$1)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "kenbquik" wrote: I have a spreadsheet that I will be updating monthly. Worksheet #1, I have the columns monthly (Jan'08,Feb'08,Mar.....Feb'10) and 11 rows that contains data (north,south¦) for different entities. Further down the spreadsheet, the data is summed together. Worksheet#2 consists of a table containing 12 months of data and a line graph that is fed from Worksheet#1. Id like to be able to enter the new data and have the table take the last column on the right that contains data for the last month say Feb 09 update the table (last column) for month and ignore the remaining columns (Mar 09¦.Feb 10) until that data is available. In this example the columns(Mar 09¦.Feb 10) sum to zero. Im not sure if I should use, lookup, offset or a dynamic range name. Also, when I tried to using the lookup function, my last column contained zeros(Feb 09) and the lookup went to the month prior(Jan 09) giving me the incorrect total for the month of Feb. 09. Please help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup, then offset? | Excel Worksheet Functions | |||
Lookup and offset | Excel Discussion (Misc queries) | |||
Lookup and offset | Excel Discussion (Misc queries) | |||
Help with Offset/Lookup | Excel Worksheet Functions | |||
lookup with offset? | Excel Worksheet Functions |