Hi experts, I'm having trouble on my formula. Please see my attachment to truly understand what i want to have in my formula.
Thank you in advance. I can only add reputation to you
Hi experts, I'm having trouble on my formula. Please see my attachment to truly understand what i want to have in my formula.
Thank you in advance. I can only add reputation to you
Can we put the total at the buttom?
Formula:Please Login or Register to view this content.
BTW the first answer should be -9 not -14 as per my calculation.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Try
F2Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
did you try the solutions? they are all separated it is just that its located at EACH end.
Can you explain how is comes -14.
Your helper coloumn "E" row 2 to 19 is "A" (you can filter & select "A")
column "C" subtotal is 15 for "A" & column "D" subtotal is 27 = -12
Look attach file.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Just change formula in
E2Formula:Please Login or Register to view this content.
Check the attached file.
Here is you file as comparison to the previous.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Ok I see it now got confused on the wrong values.
same with using
Formula:Please Login or Register to view this content.
in helper then the formula given
Use the fill handle to copy the for both column with formula....
O2, O10 O16 ->>> i can't think of a remedy otherwise a vba I thnk... maybe someone can give you that.
regards Kabayn,
Vladimir
In column N- refer to A2 and B2
=LOOKUP("zzz",A$2:A2)&MONTH(B2)
then drag down again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks