Data filtering

Closed

WF - Jul 5, 2012 at 01:49 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 5, 2012 at 07:14 AM

Hi i have a huge file of approx 40000 records of data i have a company name and there phone number i want to remove duplicate record using telephone number field can anybody tell me how i can remove duplicate record while filtering on number. i am new to excel please elaborate so i can perform it.

sheet 1
column A have names
Column b have phone numbers

i want to remove duplicate data using column B which is phone number please tell me the formula or filtering process

How to remove duplicates in excel 2003
Tmobile data check - Guide
Gta 5 data download for pc - Download - Action and adventure
Safesearch filtering is on - Guide
Digital data transmission - Guide
Transfer data from one excel worksheet to another automatically - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 5, 2012 at 07:14 AM

do advanced filter

http://www.lytebyte.com/2008/10/30/how-to-remove-duplicates-in-excel-2003/

or

http://support.microsoft.com/kb/262277

Similar discussions

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

AMD data change update new data to DMI

Hosted app data will not clear

Similar discussions

Subscribe To Our Newsletter!