Forum Discussion

Starasta's avatar
Starasta
Copper Contributor
Aug 21, 2022
Solved

Changing year to a running number

Hello!

 

I have a data set like the one in the screenshot on the left side and want to convert it to the version on the right side. With the following logic: The first appearance of a person/year combination would be set to 1, the second 2 and so on. The first year however is not always the same for every person and

the person year combination can occur multiple times. 

 

If anyone has any suggestions on how to deal with this problem I would appreciate it.

 

excel
Formulas and Functions

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Aug 21, 2022

    Starasta Give a try on below formula-

    =SUM(--(UNIQUE(FILTER($B$2:$B2,$A$2:$A2=D2))<>""))

     

     

Resources