| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how update one cell based on another cells data
Actually, enter the following formula in cell E2, with the month name in cell
C2: =INDEX({1;2;3;4},INT((MONTH(DATEVALUE(C2&" 1, 2000"))+2)/3)) It's such a habit to think the year is important, I forgot it wasn't here :-) Makes the formula even more compact... also noticed the D2 should have been C2 per your data. "BoniM" wrote: =INDEX({1;2;3;4},INT((MONTH(DATEVALUE(D2&" 1, "&YEAR(NOW())))+2)/3)) "eraasio" wrote: Guys, What I am trying to do is basd on the following column setup: A B C D E Supervisor Agent Month Score Quarter John Doe Jane Smith September 96 3 John Doe Jane Smith December 99 4 I want to simply choose the month from from a list and have the Quarter Column automatically choose the correct quarter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you create 1 chart that will update based on filtered data? | Charts and Charting in Excel | |||
| How do I get a cell to update itself based on the month we are in? | Excel Worksheet Functions | |||
| How do I update links based on a cell value? | Excel Discussion (Misc queries) | |||
| update cell in other worksheet based... | Excel Worksheet Functions | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
Threaded Mode
