Playing with increasing

[Ultralightbeam]

Hello guys,

I have this data

WeekEnding	StudentName	Teacher	Grade
1/22/2021	Fatima	Jerby	4
1/22/2021	Cheith	Ces	4
2/5/2021	Edrose	Jam	4
1/22/2021	Eliza	Ces	2
2/5/2021	Esron	Marcy	3
2/5/2021	Esron	Twin	3
2/5/2021	Esron	Rach	4
1/22/2021	Esron	Twin	3
1/22/2021	Henry	Dhon	4
2/5/2021	Angelica	Marcy	4
2/5/2021	Angelica	Twin	4
1/22/2021	Akisa	Dhon	3
1/22/2021	John	Ches	4
1/22/2021	Edrose	Ches	3

I am trying to determine the following from my given data

1. Determine increasing grade (2 week) 

 - Get same weekending and same student name and get their highest grade.  from their highest grade compare to the next weekending if grade is higher then it increasing.

Note: only get fluctuating so we will remove single row that is only consist of one week

Output

2/5/2021	Edrose	Jam	4
1/22/2021	Edrose	Ches	3
2/5/2021	Esron	Rach	4
1/22/2021	Esron	Twin	3

[grazitti_sapna · Accepted solution]

Hi @Ultralightbeam , give this a try as per the given dataset this is working.

I hope this helps. If it does then kindly mark this post as solution.

Thanks.