Thread: Calculate top 100 values in non-consecutive rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZermaPersians ZermaPersians is offline
external usenet poster
  
Posts: 3
Default 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.


Reply With QuoteReply With Quote