Excel Formulas

TradingRothIRA.com - IRA Investment Ideas, News and Stock Analysis Excel Templates!

Excel is a powerful program. However, Excel's powerful features are only as good as the person who can use it.

Now, you can make it more powerful by learning new Excel Formulas. Excel formulas for basic number crunching, as

well as more complex calculations such as payroll deductions, accounting or financial analysis.

New Excel Formulas:

How to Delete Duplicate Rows

Summary: How to Delete Duplicate Rows. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

1: Sort by duplicate log-in IDs column (in this example is column A)

2: Insert a new column

3. Input the following formula in the new column =IF(B3=B2,"Duplicate","Good")

4. Filter by Duplicate

5. Highlight the visible row

a. Highlight the rows

b. Ctrl+G > Special > Visible Cells Only

6. Delete them.