Hey,
can anyone help me with a macroSample.xlsx to lookup the numbers and merge the values based on months. data given in the attached sheet.
Output should be in a different sheet with columns 1. Number 2. Month 3. Sum value
Thanks in advance.
Hey,
can anyone help me with a macroSample.xlsx to lookup the numbers and merge the values based on months. data given in the attached sheet.
Output should be in a different sheet with columns 1. Number 2. Month 3. Sum value
Thanks in advance.
This is probably not the layout you asked for, but see if this will suite your needs...
A B C D 1 Apr-15 May-15 Jun-15 2 123456 109 117 119 3 123457 115 111 125 4 123458 121 123 113
A2=IFERROR(INDEX(Sheet1!$A$2:$A$19,MATCH(0,INDEX(COUNTIF($A$1:A1,Sheet1!$A$2:$A$19),),0)),"")
copied down
B=IF(A2="","",SUMIFS(Sheet1!$C$2:$C$19,Sheet1!$A$2:$A$19,$A2,Sheet1!$B$2:$B$19,B$1))
copied down and across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks Ford. But i am looking at the template i have given.
You actually did not really give a template, but OK.
If you want a list of months and a list of numbers, why not just sort your list, it will pretty much give the same thing
HI Ford, am just looking to figure out the logic. My workbooks are huge and data are heavy. I cannot sort things each and every time. I want the function to be refreshed when i paste the new files in a common folder. It will be a summary sheet with combination of many sheets. So kindly help me with copying from this sheet to another workbook.
The template for output is
A B C
Number Month Sum Value
I want the total rows to be reduced into 9 from 18.
Kindly anyone help on this!!
Why not use a pivot table?
Your Data is perfectly fitting a pivot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks