| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
range,cell refrence
Using excel 2007. I have a range consisting of 12 cells (monthly total
results) in a column that progressively changes in value as the year progresses. I want to automatically reference ONLY the cell corresponding to the current month. The following month the cell in the range changes. Is there a worksheet function that will give me the results of the monthly cell? -- Seamen, with their inherent sense of order, service, and discipline, should really be running the world. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range,cell refrence
I'm assuming with 12 cells that the 1st cell represents January and the 12th
cells represents December. To return the value of the cell that corresponds to the current month (assume the range of cells is A1:A12): =INDEX(A1:A12,MONTH(TODAY())) -- Biff Microsoft Excel MVP "buzz" wrote in message ... Using excel 2007. I have a range consisting of 12 cells (monthly total results) in a column that progressively changes in value as the year progresses. I want to automatically reference ONLY the cell corresponding to the current month. The following month the cell in the range changes. Is there a worksheet function that will give me the results of the monthly cell? -- Seamen, with their inherent sense of order, service, and discipline, should really be running the world. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range,cell refrence
Thank You, I've not had occasion to use the Index function before. That
worked great. -- Seamen, with their inherent sense of order, service, and discipline, should really be running the world. "T. Valko" wrote: I'm assuming with 12 cells that the 1st cell represents January and the 12th cells represents December. To return the value of the cell that corresponds to the current month (assume the range of cells is A1:A12): =INDEX(A1:A12,MONTH(TODAY())) -- Biff Microsoft Excel MVP "buzz" wrote in message ... Using excel 2007. I have a range consisting of 12 cells (monthly total results) in a column that progressively changes in value as the year progresses. I want to automatically reference ONLY the cell corresponding to the current month. The following month the cell in the range changes. Is there a worksheet function that will give me the results of the monthly cell? -- Seamen, with their inherent sense of order, service, and discipline, should really be running the world. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range,cell refrence
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "buzz" wrote in message ... Thank You, I've not had occasion to use the Index function before. That worked great. -- Seamen, with their inherent sense of order, service, and discipline, should really be running the world. "T. Valko" wrote: I'm assuming with 12 cells that the 1st cell represents January and the 12th cells represents December. To return the value of the cell that corresponds to the current month (assume the range of cells is A1:A12): =INDEX(A1:A12,MONTH(TODAY())) -- Biff Microsoft Excel MVP "buzz" wrote in message ... Using excel 2007. I have a range consisting of 12 cells (monthly total results) in a column that progressively changes in value as the year progresses. I want to automatically reference ONLY the cell corresponding to the current month. The following month the cell in the range changes. Is there a worksheet function that will give me the results of the monthly cell? -- Seamen, with their inherent sense of order, service, and discipline, should really be running the world. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refrence Problem | Excel Discussion (Misc queries) | |||
| moving the refrence to the 5th cell while dragging. | Excel Worksheet Functions | |||
| How NOT to extend formula/refrence to a cell | Excel Worksheet Functions | |||
| Change cell refrence names for whole column/row | Excel Discussion (Misc queries) | |||
| Wildcards in other workbook cell refrence? | Excel Worksheet Functions | |||
Linear Mode
