Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list something like this
A C 2 22 3 25 4 36 11 38 9 45 4 36 5 22 2 45 5 25 I would like to Sum the values in column A according to the values in column C Add the 1st largest of column C 45=11 2nd largest 38=11 3rd largest 36=8 ect when I use the =large() formula and there is more than one number, well it doesn't work, there are 2 -45's so the 3rd largest number is 38 when it should be the 2nd largest Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to find the largest change of values in a column | Excel Worksheet Functions | |||
How do I generate a list from a range of values | Excel Worksheet Functions | |||
find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
How do I return the cell address of the largest of a set of values | Excel Discussion (Misc queries) | |||
Ranking cells largest to smallest | Excel Discussion (Misc queries) |