Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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

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.

Related Topics:

- Summing on varying number of rows in Excel using VBA
- getting the sum of the last 20 cells
- Add-Ins loaded into Excel
- Getting Excel DSO Properties in VBA Code
- Percentage Rounding VBA
- Write a shell program to find the sum of the series sum=1 + 3 + 5 + 7 + …+ n
- Code for Write a shell program to find the sum of the series sum=1 + 5 + 9 + ...+ n in Unix
- sum and Multiply number and print in decimal
- Create a constructor class Sum
- Compute the sum of both positive and negative elements of an array
- sum and difference of 2 bcd numbers
- Conditional Summing
- Sum values entered into text boxes
- Data Sum rows not hidded
- sum cells with conditional formatting color
- sum of series of natural numbers
- Loop, sum values and paste
- Summing a range of variable size
- Sum colunm total in repeater
- Calculate Total Sum
- sum of amount deliverd group
- count the sum of a column
- SUM content of rows
- custom Sum function?
- sum in columns