Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Position/Level of statistics
I have a list of 4 clients:
A 1 JOSEPH 2 MARY 3 DAVID 4 ADAMS Next I have list of transactions: A B 11 JOSEPH 200 12 MARY 300 13 DAVID 400 14 ADAMS 300 12 MARY 1000 13 DAVID 900 14 ADAMS 700 So the totals of each client come upto: JOSEPH 200 MARY 1300 DAVID 1300 ADAMS 1000 I want to devise a formula for the range B1:B4 reflecting the position of each client as follows: A B 1 JOSEPH 3 2 MARY 1 3 DAVID 1 4 ADAMS 2 Because Mary & David have the highest amount of transactions they should be numbered 1, Adams is the next so 2 and Joseph, being the least, 3. Had Mary & David possess different highest amounts they would have been marked 1 & 2, while Adams & Joseph would have been numbered 3 & 4 respectively. All the help in this regard would highly be appreciated! Thanx in advance, Regards FARAZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In descriptive statistics, what does the "confidence level" mean? | Excel Worksheet Functions | |||
In descriptive statistics, what does "confidence level" mean? | Excel Discussion (Misc queries) | |||
In descriptive statistics, what is the "confidence level"? | Charts and Charting in Excel | |||
p-value, statistics | Excel Discussion (Misc queries) | |||
multi-level subtotals are in the wrong position | Excel Worksheet Functions |