Weighted Ratios

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I need urgently to calculate a weighted ratio for following type of data:
If column "B" is a single entry then column "D" = 100%
If column "B" has multiple common entries column "D" = "C" / (all common B)

A B C
7MW7 36399F927 78,977,646.86
7MW6 919CDR902 150,371,345.83
7MW7 36199Y9Z5 75,458,990.97
7MY1 36199Y9Z5 6,425.72
7MX9 36199Y9Z5 2,313.22
7MW6 36199Y9Z5 2,026,681,443.93
7MRB 36199Y9Z5 79,876,546.14
7MW7 36199Y9Z5 852,776,501.17
 
Jeff said:
I need urgently to calculate a weighted ratio for
following type of data:
Click to expand...

I believe a "weighted ratio" per se requires more information. But....

If column "B" is a single entry then column "D" = 100%
If column "B" has multiple common entries column
"D" = "C" / (all common B)
Click to expand...

No need for the special case of a single entry. Put the following formula
into D1 and copy down through C8.

=C1 / SUMIF($B$1:$B$8, B1, $C$1:$C$8)

Format D1:D8 as Percentage with at least 4 decimal places if you want to
seen any difference for the values less than 10,000.


----- original message -----
 
Back
Top