Question about Business & Productivity Software
My data operator entered alot of duplicate date in a excel sheet to increase the no of count of data. i have to search every data by its pnone no how many entry of that no is in the sheet .then i delete the all except one entry. in such a way i have to search from the whole file containing thousands of data . is there is any shortcut
Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)
Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data
Posted on Dec 29, 2007
Use COUNTIF formulae to found duplicate records in the excel spreadsheet.
Posted on Jan 13, 2008
Tips for a great answer:
Aug 02, 2009 | Microsoft Office Excel 2007
May 31, 2009 | Microsoft Office Excel 2003 for PC
Feb 19, 2009 | Microsoft Business & Productivity Software
Jul 08, 2008 | Microsoft Business & Productivity Software
Dec 04, 2007 | Microsoft Excel for PC
Sep 11, 2007 | Microsoft Office Standard for PC
Oct 21, 2016 | The Business & Productivity Software
264 people viewed this question
Usually answered in minutes!