Berkeley CSUA MOTD:Entry 39696
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/07/08 [General] UID:1000 Activity:popular
7/8     

2005/9/15 [Computer/SW/Apps, Computer/Theory, Computer/SW/Unix] UID:39696 Activity:nil
9/15    I have a stupid Excel question. It's easy to obtain the product of
        any two cells, but what is the syntax to specify that I want the
        product of, say, the previous two cells? That is, if I am in row
        A I want the product of A1 and A2 entered into A3, in row B I
        want the product of B1 and B2 entered into B3, and so on - sort of
        "relative to my position I want to do this". The rows can change
        lettering as things are inserted or deleted, but the idea is that
        I always want, say, column 1 and 2 multiplied into column 3 of the
        same row. How do I do this? I've RTFM.
2025/07/08 [General] UID:1000 Activity:popular
7/8     

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.
	...
2012/8/30-11/7 [Computer/SW/Apps, Computer/SW/Unix] UID:54470 Activity:nil
8/30    Is wall just dead? The wallall command dies for me, muttering
        something about /var/wall/ttys not existing.
        \_ its seen a great drop in usage, though it seems mostly functional.
            -ERic
        \_ Couldn't open wall log!: Bad file descriptor
           Could not open wall subscription directory /var/wall/ttys: No such file or directory
	...
2011/11/20-2012/2/6 [Computer/Companies/Apple, Computer/SW/Unix] UID:54237 Activity:nil
11/20   Are there tools that can justify a chunk of plain ASCII text by
        replacing words with words of similar meaning and inserting/removing
        commas into the text?  I received a 40-line plain text mail where
        all the lines are justified on left and right.  Every word and comma
        is followed by only one space, and every period is followed by two
        spaces.  The guy is my kid's karate instructor which I don't think is
	...
2011/10/26-12/6 [Computer/SW/Unix] UID:54202 Activity:nil
10/24  What's an easy way to see if say column 3 of a file matches a list of
       expressions in a file? Basically I want to combine "grep -f <file>"
       to store the patterns and awk's $3 ~ /(AAA|BBB|CCC)/ ... I realize
       I can do this with "egrep -f " and use regexp instead of strings, but
       was wondering if there was some magic way to do this.
       \_ UNIX has no magic. Make a shell script to produce the ask or egrep
	...
2010/11/21-2011/1/13 [Computer/SW/Languages/Web] UID:53988 Activity:moderate
11/21   Lifehacker's recommending Dreamhost as a personal web hosting service.
        Apart from csua, who do you guys use? --erikred
        \_ What do you want to use it for? Do you need CGI or PHP?  My
           brother worked for Dreamhost and said they are unethical. In
           fact, he sued them. This refers to their treatment of customers
           and employees both. I don't know who  or what "Lifehacker" is,
	...
2010/8/29-9/30 [Recreation/Humor, Politics/Foreign/Europe, Computer/Theory] UID:53940 Activity:nil
8/29    http://www.google.nl/trends?q=ramadan,+porno&ctab=0&geo=ma&date=all&sort=0
        Funny graph.  -- linkpusher
	...