| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate top 100 values in non-consecutive rows
I have a worksheet which I would like to sum the totals of the 100 cells
(same column, non-consecutive rows) with the highest values in them and place this resultant in a cell of its own. Can this be done? Thanks, Eric P.S. I posted this in the MISC group the other day but I think this group may be more appropriate. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula from consecutive rows to alternate rows? | Excel Discussion (Misc queries) | |||
| matching consecutive values | Excel Discussion (Misc queries) | |||
| Transposing data from consecutive rows into non-consecutive rows | Excel Discussion (Misc queries) | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Return Consecutive Values | Excel Worksheet Functions | |||
Threaded Mode
