T
Debbie Mayo-Smith international inspirational motivational how-to speaker technology, time management, improving business performance
Motivational Speakers, Sales, Marketing, Time Management, Productivity, Technology, Tips

(New) easy way of removing database duplicates

Want a superb instant fix for getting rid of duplicates using Excel?

It's the Exact Function. In the Function (FX) menu. Here it is step by step.

  • Sort your data in alphabetical order (name, email address).
  • Insert a new blank column.
  • Insert menu >Function (or click the little fx button)
  • in the menu type Exact. It will open the Function Exact window.
  • Click Text1.
  • Put your cursor in the first blank cell in the new column.
  • Click on the first piece of data you want to check over (such as A2)
  • Click Text2.
  • Put your cursor in the next row down of the column you're de-duping (A3)
  • Select Ok. Then drag down the function or double click the right hand corner when the plus sign appears. Not done yet.
  • Copy the whole column that is showing true/false. You'll notice they're all still formulas.
  • Select Paste Special from the edit menu (or right click). Select Values. There you go
  • Sort the new column and all the trues are - yup, the duplicates

Debbie Mayo-Smith called the Queen of Productivity is an International Motivational Business Speaker and best selling author! (http://www.successis.co.nz) Let Debbie help you with easy practical ways to improve your business profitability, personal productivity and work life balance. Debbie lives in NZ and travels the world speaking, writing and training. Why not enrol for our free newsletter?


This article is copyright to Debbie Mayo-Smith & SuccessIS. You may use it for your newsletter, website or as an article. It can be reproduced - but in its entirety and with inclusion of Debbie Mayo-Smith as the author and the weblink www.successis.co.nz


Share/Bookmark

Free Quick Tips Newsletter
You'll love this succinct monthly tip newsletter focused on improving your business results and productivity.

View and sign up now!!!

Andrew Gardner; Investors Edge

"Get on her email list mate! She sends brilliant tips every month. It’s the one newsletter I love to get!"