I have data in cell Q5:Q9, and amounts in P5:P9, where Q colum data is default and will input in same like that.
P Q
5 250 Expenses Airfare Aug-19
6 500 Expenses Airfare Jul-19
7 250 Expenses Airfare Jun-19
8 500 Expenses Airfare May-19
9 250 Expenses Airfare May-19
Now, I need a formula in Q10:Q13, Single Text from Q5:Q9 if the amounts is related to same month. For Ex: Q13 will be "Expenses Airfare May-19" and P13 will be sum of 750. and the formula has to continue to next rows if there are other months too.
P Q
10 250 Expenses Airfare Aug-19
11 500 Expenses Airfare Jul-19
12 250 Expenses Airfare Jun-19
13 750 Expenses Airfare May-19
Bookmarks