How do I calculate the average of a growing column of numbers?

Office

Question:B4 = 125B5 = 117B6 = 154B7 = 149B8 = 151B9 = 143B10 =C12 = @ sum(B4:B10)/6 which in this case = 140Now, I want to insert a line between B9 and B10 to enter a new number to include in the average. (120)The new calculation should be: C12 = @ sum(B4:B11)/7 in this case, the new average is 137.The B12 range updates when I insert said line but how can I change the number of 6 to 7 entries automatically...Read More

Posted: 01 May 2012

Tags: How do I calculate the average of a growing column of numbers How calculate the average growing column numbers

VBA to sort columns

Office

Question:I have a name column and a column next to that with time, example (0 h: 51 m: 31 s). There may be up to 10 columns, the names of 10 with 10 times.Ranges are:Column name C4: C13Time column D4: D13I would like a code to sort them to lower both the times higher in the following ranges:Column name C21: C30Time column D21: D30Thank youAnswer:HelloTry thisSub sort_Time()Dim C As RangeRange ("C4...Read More

Posted: 18 Apr 2012

Tags: VBA to sort columns VBA sort columns

Why my Excel for Mac 2011 let complete me the columns after the column IV but where to save the file and reopen it nothing past shows column IV?

Mac

Asked why I continue to lose columns beyond IV. I was told by microsoft telephone support staff member who, apparently, in this version of excel it's a natural limitation? But this makes no sense?.Probably becayse you save the file in xls format. In this mode, only 256 columns are available. Save the file as xlsx and you can fill to column XFD.Read More

Posted: 18 Apr 2012

Tags: Why my Excel for Mac 2011 let complete me the columns after the column IV but where to save the file and reopen it nothing past shows column IV Why Excel for Mac 2011 let complete the columns after column but where save file and reopen nothing past shows

Can I save the width of column in the lower half of the query design mode?

Office

Question:Query in the lower part of the screen if add an expression to the lower part of the grid (to make a calculation of the difference between the 2 fields for example) is there anyway I can save the width of the column that contains this expression?Thanks for the responses.Answer:Sure, but not yet made wishes list goes back to Access 2.0...Read More

Posted: 11 Apr 2012

Tags: Can I save the width of column in the lower half of the query design mode Can save the width column lower half query design mode

How you hide the column on the right side of the help screen

Office

How to hide the help column on the right side of the screen? |You have the Starter Edition of Excel (and the word) 2010? If so, you cannot hide the Startup pane - this is the price you pay with a free version. You must upgrade to the full version (paid) to get rid.Read More

Posted: 04 Apr 2012

Tags: How you hide the column on the right side of the help screen How you hide the column right side help screen