| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing the Duplicate entries
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.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing the Duplicate entries
=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: 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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate entries | Excel Worksheet Functions | |||
| Duplicate entries | Excel Discussion (Misc queries) | |||
| Duplicate Entries | Excel Discussion (Misc queries) | |||
| Duplicate Entries | Excel Discussion (Misc queries) | |||
| Duplicate entries | New Users to Excel | |||
Linear Mode
