Get the previous row

[Ultralightbeam]

Hey guys I want to get the previous rating of the same user from the same row

Input

Name	Week	Current Rating
Abegail	2022-07-03	Good
Abegail	2022-06-24	Best
Abegail	2022-06-10	Poor
John	2022-06-24	Poor
John	2022-06-10	Best

Output

Name	Week	Current Rating	Previous Week Rate
Abegail	2022-07-03	Good	Best
Abegail	2022-06-24	Best	Poor
Abegail	2022-06-10	Poor
John	2022-06-24	Poor	Best
John	2022-06-10	Best

[grazitti_sapna]

Hi @Ultralightbeam, try this.

Use a multi-row formula tool and type the formula. 

if [Name]=[Row+1:Name] then [Row+1:Current Rating] else null() endif

Hope this helps!

Thanks!

[flying008 · Accepted solution]

Hi, @Ultralightbeam 

as your said, the result is next row by Group [Name].   --->  Expression: [Row+1:Current Rating]