My friends question; Which is the method, good to find the duplicate records in the set of records entered in a worksheet.
Answer:
There are various methods followed to find the duplicate records in a database stored in a excel.
User has to chose the appropriate method to find the duplicate records.
Answer:
There are various methods followed to find the duplicate records in a database stored in a excel.
a.
In Excel 2007 and above, Conditional Formatting
is the easiest way.
b. Use the 'countif' formula
c. Use a Pivot table function
d. Use
Subtotal function
e. Use Advanced filter
f. Remove duplicate button Alt A, M User has to chose the appropriate method to find the duplicate records.
No comments:
Post a Comment