| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering changing months with a cell
Cells D1:AJ1 have years 2006:2038. Cells C2:C13 have Jan thru Dec. Cell A4
has the array formula =LOOKUP(9.999999999999E+307,INDEX(D2:AH13,0,MAX(IF (D2:AH13<"",COLUMN(D2:AH13)-COLUMN(D2)+1)))) ,showing the last figure entered in the table. Note: I had to push Ctrl+Shift+Enter to execute the formula. How do I enter into cell BC16 the Month corresponding to the last figure entered in D2:AH13 from column C? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing from days to months | Charts and Charting in Excel | |||
| changing dates into months | Excel Discussion (Misc queries) | |||
| entering values without changing the function in the cell | Excel Worksheet Functions | |||
| Excel - Changing value of a date by a number of calendar months | Excel Worksheet Functions | |||
| Populate 120 cell column with successive months entering only firs | Excel Worksheet Functions | |||
Threaded Mode
