Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help
Can anyone out there help me with setting up a graph for the following info.
See bottom of page for example of what i am looking Cost Centre Received in Finance No Days 2010 May-04 29 2010 May-04 15 2010 May-04 21 2001 May-04 14 2026 June-04 34 2038 June-04 30 2010 May-04 17 2028 June-04 39 2010 May-04 26 2032 June-04 15 2027 June-04 13 2017 June-04 18 2017 June-04 17 2017 June-04 21 2001 June-04 21 2038 June-04 19 2037 June-04 30 2034 June-04 15 2017 June-04 24 2038 July-04 15 2017 July-04 20 2021 July-04 27 2027 June-04 107 2021 July-04 17 2028 July-04 28 2032 July-04 76 2027 July-04 76 2032 July-04 71 2022 August-04 24 2026 August-04 33 2028 August-04 36 2028 August-04 55 2002 August-04 16 2022 August-04 33 2022 August-04 33 2022 August-04 33 I would like the report to run monthly with the cost centre on the y axis and the amount of days on the X axis. I have set out the month of June as an example. Ie CC 2027 month of June-04 = 120 Days Two occasions 2026 €œ €œ = 34 €œ One €œ 2038 €œ €œ = 49 €œ Two €œ 2028 €œ €œ = 39 €œ One €œ 2032 €œ €œ = 15 €œ One €œ 2017 €œ €œ = 70 €œ Four €œ 2001 €œ €œ = 21 €œ One €œ 2037 €œ €œ = 30 €œ One €œ 2034 €œ €œ = 15 €œ One €œ thanks M |
#2
|
|||
|
|||
Assuming first CC in D2, the date in E2, try
="CC"&D2&" month of "&TEXT(E2,"mmmm-yyyy")&" = "&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)),C2:C100)&" Days "&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)))&" occasions" and update -- HTH RP (remove nothere from the email address if mailing direct) "Monty" wrote in message ... Can anyone out there help me with setting up a graph for the following info. See bottom of page for example of what i am looking Cost Centre Received in Finance No Days 2010 May-04 29 2010 May-04 15 2010 May-04 21 2001 May-04 14 2026 June-04 34 2038 June-04 30 2010 May-04 17 2028 June-04 39 2010 May-04 26 2032 June-04 15 2027 June-04 13 2017 June-04 18 2017 June-04 17 2017 June-04 21 2001 June-04 21 2038 June-04 19 2037 June-04 30 2034 June-04 15 2017 June-04 24 2038 July-04 15 2017 July-04 20 2021 July-04 27 2027 June-04 107 2021 July-04 17 2028 July-04 28 2032 July-04 76 2027 July-04 76 2032 July-04 71 2022 August-04 24 2026 August-04 33 2028 August-04 36 2028 August-04 55 2002 August-04 16 2022 August-04 33 2022 August-04 33 2022 August-04 33 I would like the report to run monthly with the cost centre on the y axis and the amount of days on the X axis. I have set out the month of June as an example. Ie CC 2027 month of June-04 = 120 Days Two occasions 2026 " " = 34 " One " 2038 " " = 49 " Two " 2028 " " = 39 " One " 2032 " " = 15 " One " 2017 " " = 70 " Four " 2001 " " = 21 " One " 2037 " " = 30 " One " 2034 " " = 15 " One " thanks M |
#3
|
|||
|
|||
this returns 0 days and 0 occasions
thanks "Bob Phillips" wrote: Assuming first CC in D2, the date in E2, try ="CC"&D2&" month of "&TEXT(E2,"mmmm-yyyy")&" = "&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)),C2:C100)&" Days "&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)))&" occasions" and update -- HTH RP (remove nothere from the email address if mailing direct) "Monty" wrote in message ... Can anyone out there help me with setting up a graph for the following info. See bottom of page for example of what i am looking Cost Centre Received in Finance No Days 2010 May-04 29 2010 May-04 15 2010 May-04 21 2001 May-04 14 2026 June-04 34 2038 June-04 30 2010 May-04 17 2028 June-04 39 2010 May-04 26 2032 June-04 15 2027 June-04 13 2017 June-04 18 2017 June-04 17 2017 June-04 21 2001 June-04 21 2038 June-04 19 2037 June-04 30 2034 June-04 15 2017 June-04 24 2038 July-04 15 2017 July-04 20 2021 July-04 27 2027 June-04 107 2021 July-04 17 2028 July-04 28 2032 July-04 76 2027 July-04 76 2032 July-04 71 2022 August-04 24 2026 August-04 33 2028 August-04 36 2028 August-04 55 2002 August-04 16 2022 August-04 33 2022 August-04 33 2022 August-04 33 I would like the report to run monthly with the cost centre on the y axis and the amount of days on the X axis. I have set out the month of June as an example. Ie CC 2027 month of June-04 = 120 Days Two occasions 2026 " " = 34 " One " 2038 " " = 49 " Two " 2028 " " = 39 " One " 2032 " " = 15 " One " 2017 " " = 70 " Four " 2001 " " = 21 " One " 2037 " " = 30 " One " 2034 " " = 15 " One " thanks M |
#4
|
|||
|
|||
make sure that you correct the wrap-around that the NG throws up, it should
all be 1 line in the formula bar. -- HTH RP (remove nothere from the email address if mailing direct) "Monty" wrote in message ... this returns 0 days and 0 occasions thanks "Bob Phillips" wrote: Assuming first CC in D2, the date in E2, try ="CC"&D2&" month of "&TEXT(E2,"mmmm-yyyy")&" = "&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)),C2:C100)&" Days "&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)))&" occasions" and update -- HTH RP (remove nothere from the email address if mailing direct) "Monty" wrote in message ... Can anyone out there help me with setting up a graph for the following info. See bottom of page for example of what i am looking Cost Centre Received in Finance No Days 2010 May-04 29 2010 May-04 15 2010 May-04 21 2001 May-04 14 2026 June-04 34 2038 June-04 30 2010 May-04 17 2028 June-04 39 2010 May-04 26 2032 June-04 15 2027 June-04 13 2017 June-04 18 2017 June-04 17 2017 June-04 21 2001 June-04 21 2038 June-04 19 2037 June-04 30 2034 June-04 15 2017 June-04 24 2038 July-04 15 2017 July-04 20 2021 July-04 27 2027 June-04 107 2021 July-04 17 2028 July-04 28 2032 July-04 76 2027 July-04 76 2032 July-04 71 2022 August-04 24 2026 August-04 33 2028 August-04 36 2028 August-04 55 2002 August-04 16 2022 August-04 33 2022 August-04 33 2022 August-04 33 I would like the report to run monthly with the cost centre on the y axis and the amount of days on the X axis. I have set out the month of June as an example. Ie CC 2027 month of June-04 = 120 Days Two occasions 2026 " " = 34 " One " 2038 " " = 49 " Two " 2028 " " = 39 " One " 2032 " " = 15 " One " 2017 " " = 70 " Four " 2001 " " = 21 " One " 2037 " " = 30 " One " 2034 " " = 15 " One " thanks M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|