Discussion in 'BlackHat Lounge' started by soberealtor, Nov 5, 2010.
Cannot find this. Tried ablebits for excel free trial...is there any other program?
Excel 2007 or 2010 is much easier to use. If you don't have it you can download it from some file sharing sites.
iam assuming it had a duplicate removal stock now...might as well upgrade now...thanks
Excel 2003 has the option too.
Under Data>>>Filters>>>Advance Filter>>>Unique Only
You can use Notepad++
Quick way to do this with a formula in any version of excel:
if the data is in column A then first sort the column, then in cell B1 put the formula =EXACT(A1:A2) and copy the formula to the end of the data. You can remove data that is TRUE in column B.
This is useful -
textpad can sort and remove dups for you and its free
I'm assuming that since you have Microsoft Excel, you have (or can get) Microsoft Access.
Import the files into an Access MDB.
Create a new query, and go to the SQL view...
,.and so on
The result will be a de-duplicated version of the original table. "SELECT DISTINCT" is ANSI SQL, so it will also work in MySQL, SQL Server Express, or any other flavor of SQL you might have or any product that has a SQL interpreter (FoxPro, etc.).
Feel free to PM me if you need some more help.
i like poweredit
This came in handy, thanks! Need to remove duplicates asap to start posting.
You can use ASAP utilities a plugin for for Excel
I'm glad it's handy to you, I use this both at work and at home.
Separate names with a comma.