changing the Duplicate entries

N

Nitin Kapoor

Hello Friends,

I want to change the duplicate as well as triplicate entries in a table
having some codes with the help of some excel formula....i want to assign 1
at the end of code if it is a duplicate entry and 2 at the end of code if it
is a triplicate entry..

how to do that..
 
S

Stefi

=COUNTIF(A:A,A1)-1
gives 1 if content in A1 is duplicated in Column A
and 2 if content in A1 is triplicated in Column A

Regards,
Stefi

„Nitin Kapoor†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining worksheets 1
Duplicate Digits 3
How can I quickly delete duplicate entries in my address book? 1
using duplicate function 13
Show which entries in Search Table duplicates or triplicets 1
Merge 2 excel worksheets into one and remove duplicate entries. 1
A way to identify and delete duplicate entries? 6
Access Auto Matching Duplicates? 0

Top