Berkeley CSUA MOTD:Entry 26711
 Berkeley CSUA MOTD Match all Match any Histogram Relevance Most current Least current

 WIKI | FAQ | Tech FAQ http://csua.com/feed/
2019/03/26 [General] UID:1000 Activity:popular
 3/26

 2002/12/5 [Computer/SW/Apps] UID:26711 Activity:nil ```12/4 M\$ Excel qn: I have a column of 10000 numbers. Is there any easy way to create another column of 1000 numbers where each number is the sum (or average) of the corresponding 10 numbers in the first column? Thx. \_ should be do-able with the Fill-Down menuu item. \_ what exactly do you mean by corresponding 10 numbers? \_ he means you have column A which has "1,2,3,4,5,6,7,8,9,10", and he wants column B to have just one number (55) which is the sum of the 10 in column A. There is probably an automated way to do that, but I can't think of it off the top of my head. One thing you can do is to use an IF statement in column B; it should be easy to have the entry in column B be blank except for each 10th row. Having the column B rows contiguous probably takes some scripting. -tom \_ can't you have column B have the SUM(A1:A10) then just fill down? You'll have more info than you need, but you can work with that. \_ combining with tom's idea: (IF((some rule to check if this is the 10th), SUM(A1:A10), "") then fill down \_ Yes, I can use the Subtotals function if I can let it be blank except for each 10th row, but I need the numbers to be next to one another. \_ then I think you probably have to write a little macro to put a formula in each cell. There might be a different way but I've never figured out how to get "fill down" to be more intelligent about how to increment the cell references. -tom \_ "On the Accuracy of Statistical Procedures in Microsoft EXCEL 97" B. D. McCullough, and Berry Wilson Abstract: The reliability of statistical procedures in Excel are assessed in three areas: estimation (both linear and nonlinear); random number generation; and statistical distributions (e.g., for calculating p-values). Excel's performance in all three areas is found to be inadequate. Persons desiring to conduct statistical analyses of data are advised not to use Excel. (McCullough, BD, Computational Statistics and Data Analysis v31 (1999) 27-37.) [ reformatted - formatd ] \_ gee that matters when you're trying to add. \_ It's not that I like using Excel. I'm just required to use it for this particular task. Otherwise I'd just write a C program from scratch to calculate the stats and it'll still be much faster than looking through the Excel Help.```
2019/03/26 [General] UID:1000 Activity:popular
 3/26

You may also be interested in these entries...
 2013/4/9-5/18 [Computer/SW/Languages/C_Cplusplus, Computer/SW/Apps, Computer/SW/Languages/Perl] UID:54650 Activity:nil ```4/04 Is there a good way to diff 2 files that consist of columns of floating point numbers, such that it only tells me if there's a difference if the numbers on a given line differ by at least a given ratio? Say, 1%? \_ Use Excel. 1. Open foo.txt in Excel. It should convert all numbers to cells in ... ```
 2008/9/1-3 [Computer/Companies/Google] UID:51015 Activity:moderate ```9/1 THE GOOG had Scott McCloud do a comic explaining why THE GOOG Chrome (their open-source webbrowser) is cool. I don't really think it worked http://blogoscoped.com/google-chrome \_ Oh boy, it comes with porn mode! \_ Oh boy, it comes with a porn hider feature! http://blogoscoped.com/google-chrome/22 ... ```
 2008/3/17-21 [Computer/SW/Apps] UID:49481 Activity:kinda low ```3/17 Is there a way to compare differences between two substantially similar Excel and/or Powerpoint documents other than going through them manually? \_ In Excel 2003, there is a "Compare and Merge Workbooks..." option under the Tools menu. (But for some reason it is greyed out in my Excel 2003.) In PowerPoint 2003 there is "Compare and Merge ... ```
 2008/1/5-7 [Computer/SW/Apps] UID:48895 Activity:moderate ```1/5 I'm an Excel novice who needs help. Let us say I have a column of data A. I then take the absolute value of A1 and enter it in B1: (B1=ABS(A1)). All is good. My problem is when I want to delete Column A, Column B is still referencing A. How do I tell Excel to stop referencing the source data and instead let me have the result standalone? I don't want to keep A around anymore, but I ... ```
 2007/5/13-14 [Computer/SW/OS/Windows] UID:46613 Activity:nil ```5/13 Someone please give us a 411 on Windows Vista? Is activation tougher than WinXP sp2? Is it impossible to get around now forcing you to pay for upgrades? Let me just say that I don't like Windows OS. I don't mind using Microsoft Word, Excel, and Powerpoint, and they actually make decent games. However, for over a decade I've been sucked into using Windows3.0/95/98/2K/XP because ... ```
 2006/7/13 [Computer/SW/Apps] UID:43668 Activity:nil ```7/13 In Excel, is it possible to average every 24th column in a particular row. I googled this and found http://www.exceltip.com/st/Calculating_the_Average_Value_in_Every_Nth_Column,_Excluding_Zeros%09/862.html though I can't get it to work. In my spreadsheet, I have =AVERAGE(IF((MOD(COLUMN(C156:CP156)-CELL("col",C156),24)=0),C156:CP156)) It makes sense, but won't work. It seems to do the if logic only on the first column, and then just average the entire range, rather ... ```
 2006/6/13-15 [Computer/SW/Security] UID:43377 Activity:nil ```6/13 ok, memorizing all these passwords is driving me insane. I know this has been asked before but I cant find it: whats the best way to keep a password-protected file of very sensitive information? in this case, all my other passwords. thanks \_ I use http://www.bugmenot.com \_ Whatever happened to this single login thing called the ... ```
 2006/5/15-16 [Computer/SW/Apps] UID:43062 Activity:low ```5/15 MS Excel question: I have a moderately large sheet with one column filled with entries that are in this form: "num; stuff", meaning it's a number followed by a semicolon followed by anything. Is there a way to split up this column into 2, with the first containing the number and the second containing everything after the semicolon? Thanks. ... ```