How to Find, compare and retrieve values ​​from different columns?

I want to compare if a value is higher or lower after a number of tests.
If the person with a specefikt number (1a) test 5 times I want to be able to find and see if the result is higher or lower and at what stage.

For example if the person 1b lowers its earnings from time 3 and 4 (55 to 53),I want to be able to easily find it.

Sample.xlsx

Best regareds

Anders

Thank you for your prompt response and fine solution.

I was not clear enough with what I want.
I want to find the number of results reductions between what occasions these are.
I have on sheet 2 (called "results") tried to illustrate what I want, it can be several "teachers" and hundreds of persons during several stages, probably 20 at most but the majority between 3-8 stages.

I want to see how many persons "at" sees and between which "stages" most of them increases or reductions occur and if possible in an easy way "follow" a person and see when he increase or reduct.

I hope I have been a bit clearer apologize for my past carelessness.

Sincerely

Anders

sample2.xlsx

Thank you for your quick respons, i missed some information of what i want but i posted that in my other reply to ChemistB, maybe you can help me out again.
Thank you.

Best regards

Anders

Thank you very much, nice one but I donīt really understand how it works but i will try it out and see if it is what i need.

I will get back as soon as possible.

Best regards

Anders

Thanks again for your patience and quick responses.

I've tried to understand your formula and also to get it to work with my data sheets, I get neither to work and I understand that it is my poor knowledge that causes it.

I have again attached the data I need to work with and again tried to illustrate what I want, and maybe it still is your formula I need but I do not understand how to apply it.

If possible, I would also like to be able to pick up when, for example, the response to test 1 is lower than test 2 etc, see exemple in sample3, attachment.

I was hoping to figure it out myself by my earlier example of how I could solve my problem but now realize that I should have been using my actual problem.

Best regards

Anders

Sample3.xlsx

Thank you again,

Close now, so I sort first among all my data, first sort by the teacher and then by session for it to become correct?

Thanks for the explanation and for the link, I will do my best to understand and use the fomula, it seems to be a usefull one.

Is it possible to sort and see if it is the same person who lower himself between session 1 and 2 for and then lower himself again between session 2and 3 for example?

As it is right know I can see how many person it Is that lower themself between Two sessions but i dont know if the specific person lower his results the next time or if the person makes a change to a higher score then the session before.

Thanks a lot for your time and knowledge.

Best regards

Anders

Sample31.xlsx