Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
I am (with the help of this forum) successfully pulling data from a range of
cells. The range I set up was data for the month of May. What should I preceed a formula with to say If May, use range XX:XX, If June use range XX:XX, and so on. Of course each range is different than the next. Richard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
=IF(MONTH(A1)=5),value_if_true, value_if_false)
(Jan=1, Feb=2, Mar=3 etc) or =IF(TEXT(A1,"mmm")="May"),value_if_true, value_if_false) Regards Ken................... "RJJ" wrote in message ... I am (with the help of this forum) successfully pulling data from a range of cells. The range I set up was data for the month of May. What should I preceed a formula with to say If May, use range XX:XX, If June use range XX:XX, and so on. Of course each range is different than the next. Richard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
Oops typo, too many parentheses
=IF(MONTH(A1)=5,value_if_true, value_if_false) (Jan=1, Feb=2, Mar=3 etc) or =IF(TEXT(A1,"mmm")="May"),value_if_true, value_if_false) Regards Ken................... "Ken Wright" wrote in message ... =IF(MONTH(A1)=5),value_if_true, value_if_false) (Jan=1, Feb=2, Mar=3 etc) or =IF(TEXT(A1,"mmm")="May"),value_if_true, value_if_false) Regards Ken................... "RJJ" wrote in message ... I am (with the help of this forum) successfully pulling data from a range of cells. The range I set up was data for the month of May. What should I preceed a formula with to say If May, use range XX:XX, If June use range XX:XX, and so on. Of course each range is different than the next. Richard |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
For crying out loud I missed the second one:
=IF(MONTH(A1)=5,value_if_true, value_if_false) (Jan=1, Feb=2, Mar=3 etc) or =IF(TEXT(A1,"mmm")="May",value_if_true, value_if_false) Regards Ken............................. snip |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
RJJ wrote:
I am (with the help of this forum) successfully pulling data from a range of cells. The range I set up was data for the month of May. What should I preceed a formula with to say If May, use range XX:XX, If June use range XX:XX, and so on. Of course each range is different than the next. Richard If you supply the actual ranges, it would be easier to provide an exact solution. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
I am having trouble with Ken's suggestion. I'm assuming "(A1)" is a cell that
has the name of the month entered. It is formatted as "Date". Any way, what I need goes like this: If May, then =CONCATENATE(W58,S59,T59,U59,V59,W59,S60,T60,U60,V 60,W60,S61,T61,U61,V61,W61,S62,T62,U62,V62,W62,S63 ), or If June, then =CONCATENATE(Z58,AA58,AB58,AC58,AD58,Z59,AA59,AB59 ,AC59,AD59,Z60,AA60,AB60,AC60,AD60,Z61,AA61,AB61,A C61,AD61,Z62,AA62), and so on for each month. Richard "Glenn" wrote: RJJ wrote: I am (with the help of this forum) successfully pulling data from a range of cells. The range I set up was data for the month of May. What should I preceed a formula with to say If May, use range XX:XX, If June use range XX:XX, and so on. Of course each range is different than the next. Richard If you supply the actual ranges, it would be easier to provide an exact solution. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
It is always better to post sample sheet if you are not clear about your problem or your problem has wider range ....... -- mubashir aziz If this post helps Don't 4get to click Yes ------------------------------------------------------------------------ mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95483 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate based on Actual Month
I can't see the pattern in your ranges, as they appear to be different
shapes, but assuming they are what they are, why wouldn't you just use 12 helper cells somewhere in a column with your concatenations, and to the left of those cells put your months, and then just use a VLOOKUP formula to return the correct concatenation from that table based on a match with your month. You can even put it on a different sheet if you prefer. Regards Ken....................... "RJJ" wrote in message ... I am having trouble with Ken's suggestion. I'm assuming "(A1)" is a cell that has the name of the month entered. It is formatted as "Date". Any way, what I need goes like this: If May, then =CONCATENATE(W58,S59,T59,U59,V59,W59,S60,T60,U60,V 60,W60,S61,T61,U61,V61,W61,S62,T62,U62,V62,W62,S63 ), or If June, then =CONCATENATE(Z58,AA58,AB58,AC58,AD58,Z59,AA59,AB59 ,AC59,AD59,Z60,AA60,AB60,AC60,AD60,Z61,AA61,AB61,A C61,AD61,Z62,AA62), and so on for each month. Richard "Glenn" wrote: RJJ wrote: I am (with the help of this forum) successfully pulling data from a range of cells. The range I set up was data for the month of May. What should I preceed a formula with to say If May, use range XX:XX, If June use range XX:XX, and so on. Of course each range is different than the next. Richard If you supply the actual ranges, it would be easier to provide an exact solution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert X-Axis Scale from Day/Month/Year Options to Actual Numbers | Charts and Charting in Excel | |||
evaluate two cells and calculate based on criteria | Excel Worksheet Functions | |||
formula for month(s) prior to actual | Excel Worksheet Functions | |||
formula for month that is prior to actual | Excel Worksheet Functions | |||
YTD Budget Sum if Actual Month has activities | Excel Worksheet Functions |