T
T
tamweb2019-05-10 19:44:23
excel
tamweb, 2019-05-10 19:44:23

How to find duplicates in an Excel column and rename duplicates?

How to find duplicates in an Excel column and rename duplicates?
Add an ending to duplicates:

.2
.3
.4

Example:
101
102
103
101
104
102

Need result:
101
102
103
101.2
104
102.2

Answer the question

In order to leave comments, you need to log in

2 answer(s)
B
Bcoon, 2019-05-10
@Volunteer

You can use this formula:
5cd5b3f4225fb960896696.png

L
lllyx, 2019-05-10
@lllyx

Only macros in VBA

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question