I believe that you can help me with this problem if you have an experience in excel. I have an excel sheet including purchase details from customers.
Please see the image below. This is only a sample.
I want to extract balance figure out at every month end (Only the balance at month end). Can help?
When considering your requirement I think we are able to find a solution by using Microsoft excel functions. I will use some basic functions in order to solve your matter.
I will take the same example that you have been taken.
I am going to use the “if” and “month” functions in this case.
First go to the Cell F2 and type the following formula. There are many ways that you can apply these functions. However, I will give the formula directly.
=IF(MONTH(A2)=MONTH(A3),"",E2)
Now copy the same formula to below cells as shown in the below picture.
Now you can see the result that you expected.
