Forum Discussion
Solved
Merging one Column into another
Using Excel 365 for Mac. Each month I get a list of names teams and scores. (see example 1) I then have a second spreadsheet with 6 months of trends, (Example 2) Each month I have to remove the mo...
Hello Charlie,
My suggestion would be to collect the data in one worksheet and do the analysis in a second one. I did this in my example with SUMPRODUCT().Have a look at my example file. Here you can set the first month to be evaluated by changing the cell C1 in Analysis.
=SUMPRODUCT(Data!$D$2:$D$29,(Data!$A$2:$A$29=C$1)*(Data!$B$2:$B$29=$A2))The old data you can delete as you want.
Hello Charlie,
My suggestion would be to collect the data in one worksheet and do the analysis in a second one. I did this in my example with SUMPRODUCT().
Have a look at my example file. Here you can set the first month to be evaluated by changing the cell C1 in Analysis.
=SUMPRODUCT(Data!$D$2:$D$29,(Data!$A$2:$A$29=C$1)*(Data!$B$2:$B$29=$A2))
The old data you can delete as you want.
Thank you dscheikey. It took me a while to work out how to use your method, but now I understand it, the time I save will substantial each month.