Last text value for column1 should be printed for all rows of column 2

[sjayawardana]

Hi,

If the final status of each candidate = offered role, then Recruiter ideal result column should be= The recruiter relevant for offered role status.

Hope this is clear. Appreciate your help.

Candidate Name	Status	Recruiter Full Name	Timestamp	Recruiter ideal result
Candidate 1	New	PB	01/01/2020	KW
Candidate 1	Phone screened	KW	05/01/2020	KW
Candidate 1	Interview complete	PB	24/01/2020	KW
Candidate 1	Offered role	KW	22/02/2020	KW
Candidate 2	New	PB	01/03/2020	PB
Candidate 2	Phone screened	KW	07/03/2020	PB
Candidate 2	Interview complete	PB	21/04/2020	PB
Candidate 2	Offered role	PB	27/05/2020	PB

[sjayawardana]

Thank you all

[amitchandak]

@wdx223_Daniel , Try a new column

maxx(filter(table, [Candidate] = earlier([Candidate]) && [Status] = "Offered role"),[Recruiter Full Name])

[wdx223_Daniel · Accepted solution]

@sjayawardana this works in a calculated column