|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 3rd 12, 04:24 AM
|
|||
|
|||
Aggregate multiple unique values and return top 5
Hello,
I have the following sample of data in columns D & E 1.33 CCMO 1.21 ALLY 1.21 MGM 1.14 DISH 1.57 ALLY 0.25 MGM 0.25 CNK The list goes on for 200 lines. What I'm trying to do is in one clean function be able to sum the numbers in column D associated with the names in column E and return the top 5 (or 10). Ideally it would return the following on seperate cell for each: 2.78 ALLY 1.46 MGM 1.33 CCMO 1.14 DISH 0.25 CNK Does anyone know a function to do that? I've tried a lot, but can't get it to work. Thanks in advance 
|
| Ads |
|
#2
July 4th 12, 01:51 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Aggregate multiple unique values and return top 5
On Tue, 3 Jul 2012 03:24:18 +0000, dkinz > wrote:
> >Hello, > >I have the following sample of data in columns D & E >1.33 CCMO >1.21 ALLY >1.21 MGM >1.14 DISH >1.57 ALLY >0.25 MGM >0.25 CNK > >The list goes on for 200 lines. What I'm trying to do is in one clean >function be able to sum the numbers in column D associated with the >names in column E and return the top 5 (or 10). Ideally it would return >the following on seperate cell for each: >2.78 ALLY >1.46 MGM >1.33 CCMO >1.14 DISH >0.25 CNK > >Does anyone know a function to do that? I've tried a lot, but can't get >it to work. > >Thanks in advance You could use a Pivot Table Drag the Names to the Rows area Drag the Values to the Value area Sort by Values Descending.
|
|
#3
July 4th 12, 09:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Aggregate multiple unique values and return top 5
dkinz used his keyboard to write :
> Hello, > > I have the following sample of data in columns D & E > 1.33 CCMO > 1.21 ALLY > 1.21 MGM > 1.14 DISH > 1.57 ALLY > 0.25 MGM > 0.25 CNK > > The list goes on for 200 lines. What I'm trying to do is in one clean > function be able to sum the numbers in column D associated with the > names in column E and return the top 5 (or 10). Ideally it would return > the following on seperate cell for each: > 2.78 ALLY > 1.46 MGM > 1.33 CCMO > 1.14 DISH > 0.25 CNK > > Does anyone know a function to do that? I've tried a lot, but can't get > it to work. > > Thanks in advance In the 5th place, why 0.25 CNK and why not 0.25 MGM ??? Bruno
|
|
#4
July 4th 12, 10:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Aggregate multiple unique values and return top 5
After serious thinking Bruno Campanini wrote :
> In the 5th place, why > 0.25 CNK and why not > 0.25 MGM > ??? Please don't rake into account the preceeding questions. Bruno
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can COUNTIFS be utilized to return unique values? | ascottbag-hcm | Excel Worksheet Functions | 1 | October 27th 09 09:28 PM |
| Vlookup & return multiple unique values | nikko | Excel Worksheet Functions | 14 | May 5th 09 07:02 AM |
| How to return unique values only | nikko | Excel Worksheet Functions | 4 | May 5th 09 04:06 AM |
| Return unique values from 2 different ranges | John[_140_] | Excel Programming | 1 | April 1st 09 05:53 AM |
| Aggregate Unique part no in cells to sum qty | Marty Marshfield | Excel Discussion (Misc queries) | 4 | September 20th 07 02:06 AM |
Linear Mode
