Can one sort an OpenOffice.org spreadsheet by checking for duplicated entries?
606125
sort the data by cell phone number\n\ninset a column to the right of the number column.\n\nin the first cell, enter this formula:\n=if(a1=a2,1,0)\nwhere "a" refers to the column with the numbers.\n\nhighlight the cell with the formula.  copy it.\npaste is all the way down to the end of the column.\n\nhighlight the column with the formulas.  copy it.  go to the edit menu, choose paste special and choose values.\n\nsort data by the column with the 1s and 0s in it.  anything with a 1 is a duplicate.
474688
Custom lists are your answer.\n\nFirstly, create a column with the rankings, in descending order, A+ down to C-.  Then select the list, and go to Tools / Options, and then the Custom Lists tab.  The cells selected should be in the Import box on the bottom right; click Import to add them to a custom List.\n\nNow you can sort by this custom list.  Select your main dataset (i.e. the list of downloaded data), and go to sort as per normal, by your ranking column.  However, before sorting in Descending Order, click the Options... button.  From the dropdown menu in here, you can select all the custome lists available - and hence get it to sort by your A+ to C- ranking.\n\nHope that helps!
393430
http://www.openoffice.org/ - It is similar to Microsoft Word and Excel and it is free.
8921
It's painful. Open the PDF, Ctrl-A to select all, then Ctrl-C to copy. Open metapad (see below). Use Find/Replace to replace all spaces (" ") with tabs ("/t"). Then replace all incidences of two tabs ("/t/t") with one tab ("/t"). Keep doing that until it complains "Replaced 0 items".\n\nDelete everything you know you won't need in the spreadsheet. Ctrl-A to select all, ctrl-C to copy. Open up a new Excel spreadsheet, and Ctrl-V to paste.\n\nHopefully the result is NOT a hideous mess.
801228
I'm using Excel 2003. This solution should work for any recent version of Excel. \n\n1. Select the entire worksheet. You do this by either 1) clicking on the "select all" button, which is located between the labels for row 1 and column A (the very top left corner), or 2) press "Ctrl+A".\n\n2. On the top bar menu, choose Data/Sort. Choose the column on which you want to sort. (It almost doesn't matter for your purpose, but if you have a preferred order you might as well choose it now.) \n\nBe sure that the order is Ascending for now, even if you want it to be Descending in your final sort.\n\nIf your worksheet has a header row, you'll want to select the "Header row" radio button. If you choose this option, your header row (row labels) will stay at the top of your sort. If you choose "No header row," the header row labels will sort with the rest of your data.\n\n3. Click "OK." If the sort order is Ascending, your blank rows should be at the bottom of your list. If you had chosen to sort in Descending order, the blank rows would be at the top and you'd have to do a follow-up step of selecting the blank rows and deleting them. \n\nHope that helps.
310068
http://www.openoffice.org\n\nIts spreadsheet program will open an Excel file, and unlike the viewer, you'll be able to edit the data.
503428
Yes!  http://www.openoffice.org is a free office suite!
30278
If they have been saved as an Excel spreadsheet with the .xls extension it can. Meaning, anytime you want to save something in OpenOffice, select "Save As" and then select to save it as an Excel document. You can  even set it so that it does that by default every time.
759334
If you want something similar, a free word alternative like OpenOffice.org should help. (The .org is in the name probably so people know where to get it.) It includes a spell checker, and is open-source (and thus free)
26959
I'd copy the emails from each sheet & do a vlookup to each set. Delete the ones that are matched & then do a vlookup to the original sheets to bring ini the rest of the details.\nI'd take them into Access tho if you can. You could link the sheets to a data base & export the query results back to Excel.
897637
Is there a macro hidden in it somewhere, that is running every time you open it? This is _a_ possible solution...\n\nRawlyn.
175683
try customizing one of the ones from MS Office\n\nhttp://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=order+form
232585
This is similar to Microsoft Word, and has a grammar check:\nhttp://www.openoffice.org/\nand here are some free downloads from Microsoft:\nhttp://www.microsoft.com/downloads/Search.aspx?displaylang=en
947994
If you're looking for a free spreadsheet application, the best free one available would have to be the spreadsheet that is distributed with OpenOffice.\n\nhttp://www.openoffice.org\n\nIt's a large download, though, so hopefully you've got broadband.
218271
It's not new I've used it for at least a year, downloaded it to avoid paying extra for MS' office suite. It opens all office documents with no problem and haven't had any trouble with compatibility between stuff I do at home on open office and send to work to use in MS office applications. \n\nThere's another free suite called 602PC  I tend to prefer the spreadsheet application in 602pc but I couldn't tell you why. Everything in 602PC is compatible with MS office also.
142698
OpenOffice - the free open-source suite is available at openoffice.org.
67779
1) Open Office v2.x\nhttp://www.openoffice.org/\n\n2) http://www.e-press.com/home.asp \nLook for the free version; The software recently changed so it might not be free anymore...doesn't hurt to check it :)\n\n3) 602 Suite i still have in my URL links too.  See if there is still a free version for that :)\nhttp://www.software602.com/products/pcs/\n\nThere are some individual programs out there that mimic or can open Word, or Excel, but I would just go for the Suite(s).\n\nHave fun!