formulas

  • Thread starter Thread starter FUNACH
  • Start date Start date
With your values in A1 to A10. Try and feedback

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))

If this post helps click Yes
 
With your values in A1 to A10. Try and feedback

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))

If this post helps click Yes
 
yes, i luv u, thanks so much!

Jacob Skaria said:
With your values in A1 to A10. Try and feedback

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))

If this post helps click Yes
Click to expand...
 
yes, i luv u, thanks so much!

Jacob Skaria said:
With your values in A1 to A10. Try and feedback

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))

If this post helps click Yes
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL 10
optimization 1
average out of bottom 10 values 5
INDEX MATCH SMALL 12
Excel How To Create A Min Formulas That Will Take The 4 Min Value In Ascending Order 4
Extract the 2 Lowest % 3
#DIV/0! error using Avgerage 15

Back
Top