Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how update one cell based on another cells data
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how update one cell based on another cells data
Try
=IF(OR(D2="January",D2="February",D2="March"),1,IF (OR(D2="April",D2="May",D2="June"),2,IF(OR(D2="Jul y",D2="August",D2="September"),3,IF(OR(D2="Octoboe r",D2="November",D2="December"),4,"No Month"))) "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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how update one cell based on another cells data
=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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how update one cell based on another cells data
=INT((MATCH(LEFT(C2,3),{"jan","feb","mar","apr","m ay","jun","jul","aug","sep","oct","nov","dec"},0 )-1)/3)+1
best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "eraasio" wrote in message ... 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. |
#5
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. |
Reply |
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) |