ExcelBanter - Weighted Ratios

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Weighted Ratios (https://www.excelbanter.com/excel-discussion-misc-queries/257778-weighted-ratios.html)

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" wrote:
I need urgently to calculate a weighted ratio for
following type of data:

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)

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 -----

"Jeff" wrote:
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

D1: =c1/countif(B:B,b1)

Copy down.

Regards,
Fred

"Jeff" wrote in message
...
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