Check duplicate values and fill another column based on it

[jpscoralick]

Hello everyone!

Every month I handle a Excel table like the first one below.
When I found a duplicate NUMBER, I need to fill the CHECK column with 0 and the VERSION column with v2 or vN (in case of N duplicate lines), resulting on the second table below.

EXPECTED RESULT

Could someone help me on how to do this?

Thanks in advance!

[binuacs · Accepted solution]

@jpscoralick One way of doing this#

[jpscoralick]

Excellent solution, @binuacs. Thank you!