Question about Computers & Internet
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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jun 10, 2014 | HP Office Equipment & Supplies
Jan 30, 2012 | Microsoft Office Outlook 2003 for PC
Transmitted Error Count 4734440
Ack Rcv failure Count 15269951
Feb 27, 2011 | D-Link AirPremier DWL-3200AP 802.11g/b...
Aug 02, 2009 | Microsoft Office Excel 2007
Feb 19, 2009 | Microsoft Computers & Internet
Aug 19, 2008 | Excel (SS8SATAS5128400R)
Jul 08, 2008 | Microsoft Computers & Internet
Sep 11, 2007 | Microsoft Office Standard for PC
272 people viewed this question
Usually answered in minutes!