Hi I’m looking for some help, and I apologise for my lack of excel know-how.
I want to create a leader board where I can enter the date into cell Y2 and the leader board will populate in raking order (Lowest to Highest)
In the example doc I have selected the date of 1/8/17 into Y2 which has taken the results (Total time per day) from B3:U3 and created the leader board showing the members name and time
For this issue to be resolved the user could change the date in Y2 and the leader board would auto update. For an example please see Sheet2 which shows the date of 2/8/17
Many thanks in advance for your help.
Eddie
Bookmarks