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!

binu_acs

@jpscoralick One way of doing this#

Version_012323.yxmd