Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
averages in pivot tables | Excel Discussion (Misc queries) | |||
Function for generating monthly & weekly averages | Excel Worksheet Functions | |||
Trouble Sorting Averages of Randomly Generated Numbers | Excel Discussion (Misc queries) | |||
calculating averages | Excel Discussion (Misc queries) | |||
how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions |