How to take a month figure in excel?

Asked By 10 points N/A Posted on -
qa-featured

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.

Monthly purchase excel

I want to extract balance figure out at every month end (Only the balance at month end). Can help?

SHARE
Answered By 0 points N/A #134422

How to take a month figure in excel?

qa-featured

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.

Excel Functions

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)

function for excel

Now copy the same formula to below cells as shown in the below picture.

same formula to rows

Now you can see the result that you expected.

Login/Register to Answer

Related Questions