averages
 

in vba
hi how do i make a formula to give me the average of a strip of data
say a6 until the last piece of data in colomn a
and then
in msg boxs
1)tell me the average
2) the highest value
3) tell me the number of instances
4) how many of these are above a certain number and this as a percentage
please could these numbers also be accesable in the code for storage in the
sheet
thanks guys

averages
 

I'll give you formulae that can return those numbers, but a MsgBox requires
VBA.

1) A simple avearge does that as it ignores blanks =AVERAGE(A6:A2000)

2) =MAX(A6:A2000)

3) =COUNTA(A6:A2000)

4) =COUNTIF(A6:A2000,"10")

just adapt the range to suit.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ashw1984" wrote in message
...
in vba
hi how do i make a formula to give me the average of a strip of data
say a6 until the last piece of data in colomn a
and then
in msg boxs
1)tell me the average
2) the highest value
3) tell me the number of instances
4) how many of these are above a certain number and this as a percentage
please could these numbers also be accesable in the code for storage in
the
sheet
thanks guys