Mamdouh Elfors
Member
Hello, I have distributions with percentages in 5 tables. I want the same distribution, using equations, to be generated manually in the required table.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Distribution in one table
- Thread starter Mamdouh Elfors
- Start date
What 'says' that there are always four rows per 'table'N?
> Would Your next thread has eg seven rows per 'table'N?
or
even that every 'table'N could have different rows?
OR
as You've those five tables solved
You could get required table with
for cell C29
> Would Your next thread has eg seven rows per 'table'N?
or
even that every 'table'N could have different rows?
OR
as You've those five tables solved
You could get required table with
for cell C29
=SUM(C2,I2,O2,U2,AA2) ... and copy as neededMamdouh Elfors
Member
Each table contains only four rows.
These rows may overlap with other tables. For example, Table 1 starts in January and ends in April, while Table 2 starts in March and ends in June. Therefore, I have to separate the two tables. However, I want to record everything in a single table, as shown in the required table, so that it gives the same results as separate tables. I will delete the five tables and keep only the required table.
These rows may overlap with other tables. For example, Table 1 starts in January and ends in April, while Table 2 starts in March and ends in June. Therefore, I have to separate the two tables. However, I want to record everything in a single table, as shown in the required table, so that it gives the same results as separate tables. I will delete the five tables and keep only the required table.
Mamdouh Elfors
Member
I have Excel 16
You commented only my last wondering ...
... basic sum-function needs those Your tables ... okay?
>>> Why You have those AH6:AJ11 -values?
My sample ...
Check Sheet2
Below [ DoIt ] ... have those manually given 'months' (( Bold Black ))
Below tot ... have those manually given values as 100, 50, 80, 150,120 (( Bold Black ))
... there could be more of those
More right side...
You could modify those A, B & C as You would like to (( Black ))
... and You could add there of those too.
Below of those A, B & C...
there can be ONLY number of USED rows values (( Red )) (each rows sum gotta be 100%)
The most right side is Your original %-table.
Those columns can delete.
Usage
After modified/verified 'months', tot and right side data
... press [ DoIt ]-button
... basic sum-function needs those Your tables ... okay?
>>> Why You have those AH6:AJ11 -values?
My sample ...
Check Sheet2
Below [ DoIt ] ... have those manually given 'months' (( Bold Black ))
Below tot ... have those manually given values as 100, 50, 80, 150,120 (( Bold Black ))
... there could be more of those
More right side...
You could modify those A, B & C as You would like to (( Black ))
... and You could add there of those too.
Below of those A, B & C...
there can be ONLY number of USED rows values (( Red )) (each rows sum gotta be 100%)
The most right side is Your original %-table.
Those columns can delete.
Usage
After modified/verified 'months', tot and right side data
... press [ DoIt ]-button
Note: I have NOT checked everything
Attachments
You can replicate the distributions by using formulas that calculate each value based on the percentages. For example, if you have a total value in a cell, multiply it by the percentage for each row or column to fill your new table. In Excel, it would look like =TotalCell*PercentageCell. Make sure the percentages sum to 100% for consistency.