Posted to microsoft.public.excel.misc

Jeff

external usenet poster

Posts: 921

Weighted Ratios

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ratios	KCR	Excel Worksheet Functions	4	October 22nd 08 09:24 PM
ratios	Kieran. G	Excel Discussion (Misc queries)	1	June 13th 08 12:14 AM
I need help with ratios	Cin	Excel Discussion (Misc queries)	11	October 18th 07 10:07 PM
ratios	RAPPEL	Excel Discussion (Misc queries)	1	July 12th 06 03:05 AM
Ratios	alice	Excel Discussion (Misc queries)	2	February 28th 06 01:14 PM

All times are GMT +1. The time now is 02:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us