Kindly use the table on data if you have large dataset and updating frequently, Assuming there is a unique loan number, a pivot table is best suited for such cases.
You can group the dates as quarters, and apply to the pivot table.
Sum of Pinciple
Sum of Interest
Hi Excel Experts,
I work with large data sets in excel and very frequently apply the Vlookup formula.
In the Vlookup formula there is an parameter called Col_Index_num, where we key in the result column number.
ex: Columns A:F, we key in as 6 , as need the result from F Column, this range...
Hi, I also face a similar situation in my work, I just apply the text to column and again concatenate on the relevant column(I sort on the last relevant column and then concatenate , like in your data the pain area is the Street No. and Name and the City.
The weight and size needs to be under the parcel size so e.g. 4L and 4kg will fit within the second tier of $6.54 / $9.74. Even though 4L is under 12L, the weight pushes it into the next bracket.
You are just looking at the L & not the weight, weight 4 Kg is above 3kg & below 5 Kg...
I guess the best & the easier way is to apply Pivot table & use slicers for filtering.
I have just shown a sample in the attached file. Kindly ref sheet2.
The slicers can be rearranged & customized.
@ Bosco, thanks for the quick reply, I want the formula in N2 Column. Your formula works for Rows, I want it column wise. My data is from A2:M500 & the formula should be in N2 to N500. Uploading a sample file. Thanks
A:L column has months like April'16, may 16..........April 17. As of now the data is filled only from April - July. I want the rolling total for 4 months. When the data is entered for Aug, the formula should sum up from May to Aug. When the data is entered for Sept the formula should sum...
@ Chihiro thanks for the quick updates. I agree with you its a design flaw. The space is very narrow. Actually I need to summarise around 15 fields month on month. So I was looking for a better way of doing it. Is there any better design or any another way of doing this task.