Need a help with Formula

[KapardhiSarma]

Hi team,

I was trying to write a formula to get data. My requirement is as below.

I want to get the sales, $ and % of a project by month in the column next to project which is available on a different tab in the excel.

Say i have 5 project numbers and data of 12 months in another tab, now i want a project's $ and % by month June'13, July'13 and August'13 side by side in this sheet.

Please help me with this formula.

Thanks,
Kapardhi

 

[Ravi Verma]

Hi Kapardhi,
Could you please share the file?
Regards,
Ravi Verma

 

[KapardhiSarma]

Hi Kapardhi,
Could you please share the file?
Regards,
Ravi Verma

Hi Ravi,

Please find the attachment.

Thanks,
Kapardhi

 

[Xiq]

Hi there,
I've thrown some things in a PivotTable. Because I'm not sure what you actually want, not familiar with the jargon or how it supposed to look like... it may need some tweaks

See attached file.

 

[Ravi Verma]

file attached .. let me know if it helps you

 

[KapardhiSarma]

file attached .. let me know if it helps you

This is exactly what i wanted Ravi. Thanks you very much for your help.
Please can you tell me why you used + after = in the formula?

Thanks a lot again.

 

[Ravi Verma]

Your Welcome KapardhiSarna ...

+ and = doesnt make any difference in the formula ... its nothing special.

 

[Xiq]

file attached .. let me know if it helps you

I like this piece of your solution:

(TEXT(Sheet2!$B$2:$B$1215,"yyym")=TEXT(Sheet1!B$1,"yyym")

I could have used that a few times in the past

 

[Ravi Verma]

Your Welcome