ranking

I made a weight recording app. But I want employees to know who ranks each week.
Please help an expert please advise me.
Divided into 7 week sequences, each week will display a sequence.

such as
week 1
Mr. A is fat 41.24
Mr. B is fat 35.0
------------------------------------- -------
Week 2
Mr. A fat 35.24 (fat reduced by 6)
Mr. B Fat 32 (Lower Fat 3)
------------------ ---------------------------
Week 3
Mr. A fat 30.24 (fat reduced by 5)
Mr. B fat 24 (lost fat 6 )
---------------------------------------------
Week 2 Mr. A must be 1st and Mr. B 2nd // In the 2nd week Mr. B must be 1st and Mr. A 2nd.

The first image is the one that the user calculates in Excel but wants in the life app to show their weekly ranking.

numfon_naka_0-1676356564047.png

------------------------------------------------------------------------------------

In the app, want to display the order .

Week 1 = Rank 1

Week 2 = 2nd place

Week 3 = 5th place

week1.png

Do I have to make the columns separate weeks?

---------------------------------------------------------------

 

1 2 104
2 REPLIES 2

Did you get this SORTED out?

Do you want to sort it according to the weight? From Highest to lowest?

Top Labels in this Space