ExcelBanter - changing the Duplicate entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - changing the Duplicate entries (https://www.excelbanter.com/excel-worksheet-functions/206082-changing-duplicate-entries.html)

Nitin Kapoor

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..

Stefi

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..

All times are GMT +1. The time now is 09:42 AM.