Forum Discussion

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

excel

Formulas and Functions

Harun24HR
Aug 21, 2022
Starasta Give a try on below formula-
=SUM(--(UNIQUE(FILTER($B$2:$B2,$A$2:$A2=D2))<>""))

Harun24HR

Bronze Contributor

Aug 21, 2022

Starasta Give a try on below formula-

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