Calculate the difference of the same Name between two closest date and show it by up and down arrows

[Hayoung]

I would like to calculate the score difference between the lastest score and its closest past score of the same Name, and then show the difference by show the green up, red down and no change symbol. Also, I would like to test whether the change has a significant change in the difference by one-tail t test when comparing it, and show it as a filled circle and non-filled circle. Below is the small sample data.

Index	Name	ID	Question	Score	Date
1	A	1	Q1_A1	10	1/9/2022
2	A	2	Q1_A2	8	3/9/2022
3	C	1	Q1_A5	0	5/9/2022
4	A	3	Q1_A4	2	11/9/2022
5	B	1	Q1_A2	8	18/9/2022
6	C	2	Q1_A3	5	19/9/2022
7	A	4	Q1_A3	5	20/9/2022
8	A	5	Q1_A2	8	21/9/2022
9	B	2	Q1_Q1	10	22/9/2022
10	C	3	Q1_A1	10	24/9/2022

Q & Ans no.	Score
Q1_A1	10
Q1_A2	8
Q1_A3	5
Q1_A4	2
Q1_A5	0

[tamerj1]

Hi @Hayoung 
Please include the difference with the expected results sample table.