Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a range of months can I capture the most current month entry?
I have a spreadsheet with months accross the top. In my total column I want
to capture the number in the most recent month. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a range of months can I capture the most current month entry?
The number, is it one number or what, please try to describe more in detail
what you want. Are the months simply text values like Jan or January, Feb/February. In what cell do they start, in what cell do you put the number (the adjacent cell below the month etc)? -- Regards, Peo Sjoblom "Karlene" wrote in message ... I have a spreadsheet with months accross the top. In my total column I want to capture the number in the most recent month. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a range of months can I capture the most current month entry?
Your question is a little thin on details but perhaps this will give you a
start... http://www.xldynamic.com/source/xld.LastValue.html -- HTH... Jim Thomlinson "Karlene" wrote: I have a spreadsheet with months accross the top. In my total column I want to capture the number in the most recent month. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a range of months can I capture the most current month entry?
Karlene,
There are any number of ways to do this, based on how you have your data laid out. If you are laying it out a year at a time, you could use a VLOOKUP based on the month and the current date; you could use an OFFSET using MONTH(TODAY()) as your horizaontal offset. If your monthly data is really a cumulative amount and that's why you are only looking for the current month's total, you could make two rows - one for monthly and one for cumulative and sum the monthly row. Does any of that help? "Karlene" wrote: I have a spreadsheet with months accross the top. In my total column I want to capture the number in the most recent month. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a range of months can I capture the most current month entry?
Are the months full dates? And what defines most recent month, the one that
today is in, the date above not later than today? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Karlene" wrote in message ... I have a spreadsheet with months accross the top. In my total column I want to capture the number in the most recent month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
Highest 12-Month Period Average Over Range of Months | Excel Worksheet Functions | |||
Graphing past months (totals) and current month (weekly total) in | Charts and Charting in Excel |