Berkeley CSUA MOTD:Entry 49481
Berkeley CSUA MOTD
2019/01/18 [General] UID:1000 Activity:popular

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
           Presentations...".  I've never used either, though.
           \_ Sounds great, but I cannot find this in Office 2004 for Mac.
              \_ Search for "merge workbooks" in Excel help, it explains
                 what you need to do to merge two workbooks. I think you
                 will need to share one of your workbooks and then make
                 a copy of it. In the copy you need to paste in the other
                 workbook. Then you can use the merge feature to merge the
                 two together and see the changes.
        \_ Save them in the office XML format and compare those with diff.
           \_ How do I save in XML? I don't see that as an option.
              \_ AFAIK, you need Office 2007/2008 to export to XML. Earlier
                 versions don't support XML.
                 \_ I thought you could always save in some sort of text
                    format (tab delimited or whatever). I'd look for that.
                    \_ For Excel you can but it is primitive. For Powerpoint,
                       I dunno.
                    \_ I think all versions of Excel can export to comma
                       separated and tab delimited text files, but it can
                       be pretty hard to compare these files.
        \_ My wife who's an accountant asked me the same question back when
           Excel 2000 was the latest version, and here's the solution I
           1. Open the two files in Excel, say foo.xls and bar.xls.
           2. Find out how many rows and columns there are in Sheet 1 in
              foo.xls and bar.xls.
           3. Create a new file.
           4. For Sheet 1, Cell A1 in the new file, enter
           5. Highlight Cell A1, click Edit -> Copy.
           6. Highlight the same number of rows and columns as in foo.xls and
           7. Click Edit -> Paste.
           8. Click Edit -> Find.  Under "Look in:", choose "Values".
           9. Under "Find what:", enter "false", click "Find All".
           You'll have to repeat this if there are multiple sheets in foo.xls
           and bar.xls.  You'll have to replace EXACT() with another function
           if you want case-insensitive comarison or if you want to find
           formatting differences.
           --- yuen
2019/01/18 [General] UID:1000 Activity:popular

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
        \_ Oh boy, it comes with porn mode!
        \_ Oh boy, it comes with a porn hider feature!
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,_Excluding_Zeros%09/862.html
        though I can't get it to work.  In my spreadsheet, I have
        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/30-7/5 [Computer/SW/Apps] UID:43545 Activity:nil
6/30    Can anyone recommend a good site that has professional looking
        Powerpoint templates, for free? Thanks.
        \_ screw powerpoint, S5 all the way
                \_ Well given what's available at this conference, it has
                   to be PPT. So forget the "screw powerpoint" advice. -op
        \_ Make your own.  It's not hard.  Drop me a line (email in my
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
        \_ 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?