Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Getting the sum and percentage in Excel coulmn

  Asked By: Sreeja    Date: Feb 13    Category: MS Office    Views: 1530
  

Hello All,

I have a specific requirement which is as below.

Emp id Outcome Cumulative %
P1 1 logic ( 1/sum of coulumn outcome)*100
P2 2 logic ( 1+2/sum of coulumn outcome)*100
P3 6 Logic ( 6+1+2/sum of coulumn outcome)*100
P4 4 Logic(4+6+1+2/sum of coulumn outcome)*100
P5 5 Logic(5+4+6+1+2/sum of coulumn outcome)*100


The problem here is I cannot write direct formula because emp id and outcome is not fixed. It can grow up to any limit. So can any one tell me that how to fill the cumulative % coulmn by using a Excel VBA and stop the calcullation once the last value cell in emp id is recahed.

Many Thanks,
SP

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Getting the sum and percentage in Excel coulmn Or get search suggestion and latest updates.




Tagged: