Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Sunday, 24 September 2017
  1 Replies
  7.2K Visits
0
Votes
Undo
I want macro for: I have 5 columns where I want like

COL 1 COL 2 COL 3 COL 4 COL5
JAN 13 4 excel.png excel.png 1
JAN 12 8 7
FEB 13 7 4
FEB 14 7 5
MAR 44 10 7
now i want to calculate on col 5 = (sum of col2 values ) / (sum of col 3 values- sum of values col 4) which belongs to JAN and i want this solution to print on 1 cell of COL5

similarly for other months output should print on first cell belongs to FEB cell in col 1

Please i am very poor in this macro coding part . can someone help me to decode this one.

For better understanding of my problem i attaching image also
5 years ago
·
#1217
0
Votes
Undo
Hello,
The screenshot is too small.
Please try to update your images. :)
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL