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

 WIKI | FAQ | Tech FAQ http://csua.com/feed/
2018/10/20 [General] UID:1000 Activity:popular
 10/20

 2003/12/14-15 [Computer/SW/Apps] UID:11457 Activity:nil ```12/14 Is there a way in Excel to do y=0 for n=1:100 y=y+x^n end where x is the value in a particular box, say E2. Obviously, I can do this manually for 100 boxes and then sum them, but I'm looking for a more elegant way. \_ I don't know how to do it, but i'm pretty sure the answer is yes, there is a way. Excel will let you define macros using visual basic. look under the "tools" pulldown menu. \_ A1 = 1, A2=A1+1, copy A2 to A3-A100 B1 = X^A1, B2 = B1+X^A2, copy B2 to B3-B100 B100 is your final answer -nivra \_ Nothing is impossible with Excel: http://www.geocities.jp/nchikada/pac```
2018/10/20 [General] UID:1000 Activity:popular
 10/20

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. ... ```
Cache (363 bytes)
 www.geocities.jp/nchikada/pac -> www.geocities.jp/nchikada/pac/ All actions are expressed by rewriting of a cell background color. Each one of cells as a dot, and move it by make cells background color high-speed rewriting. Although I did not think its possiblele, but now its possiblele by the favor of the improvement in a performance of a personal computer. Im very happy if you feel Excel & VBA has an infinite possibility!