worksheetfunction.average

Hello, this is my first time on mr. excel so I hope I do not mess up anything in the post. I have to create what is basically an averaging program. The data (thousands of points) is imported from a notepad file and i need to create a userform/macro that accepts a block size and compresses...

Hi All, I have 5 different values in five variables, in that some values are negative, so i want to take average only for positive values.. plz help me thanks Deepak

Hello, I have a long string of numbers, some negative some positive (representing a Sine curve). I am trying to average consecutive set of positive and negative numbers (average the 10 positive numbers, then 9 negative numbers, then the following 11 positive numbers, etc) I currently have...

I am trying to calculate average and SD from data which has different start points on a worksheet. The data is in column I and the first set starts at I2 and varies where it finishes. The second set starts 6 rows below where the first set ends. Cells(2,16).Value =...