I have a spread sheet that is built automatically using a macro,,,,
I would like row "2" of each column to show the running average of the column as the spread sheet grows in row's
the macro is set to only fill 5000 rows so I've tried =AVERAGE (C3:C5000) but it does not work,,,, i assume this is because at this time only 50 rows contain numbers
cheers
In what way does =AVERAGE(C3:C500) not work?? What is in the "empty" cells?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
when I put =AVERAGE(C3:C5000) in cell C2 it show's "#value!"
the empty cells "C51 to C5000" are blank as the macro has not yet filled them
cheer's
Last edited by semajjames; 03-29-2015 at 11:57 AM.
Can you attach your worksheet? Remove anything confidential first.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
I've fixed it ,,,,,,
I made a simplified version to upload and everything worked fine
so I checked the real data and found some corrupt cell's
thank's for looking
Lucky you!! I couldn't uunderstand what was wrong as it should have worked perfectly well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks