Thread: How do I average a row of 13 enries using the 8 highest in value.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jacqhty jacqhty is offline
external usenet poster
  
Posts: 1
Default How do I average a row of 13 enries using the 8 highest in value.
Entries in cells
E3 - 27
F3 - 35
G3 - 82
H3 - 15
I3 - 100
J3 - 86
K3 - 50
L3 - 51
M3 - 65
N3 - 19
O3 - 90
P3 - 12
Q3 - 85
I am using Excel 2003. I have a spreadsheet with many rows of information.
For each row I need to take the eight highest entries and find the average.
Reply With QuoteReply With Quote