@peter2 Thanks for the time you put into the update of the Competition.
I do have a backup spreadsheet for the yearly comp just in case you take off on us and go on a cruise or extended overseas holiday
.
I have each tipster's data box set up roughly the same as you but I don't save each month's data.
I copy/paste latest prices into the spreadsheet next to ASX codes list for all the stocks then I have the VLOOKUP formula to retrieve prices from this list. So all latest prices for each stock in tipster's box fill in automatically.
I don't sort each tipster's box, the leader board I have automatically drags each tipster's profit % next to their name then I highlight all names and percentages then sort highest to lowest (1st to last).
@peter2 If I can help you in any way or if any part of the spreadsheet is helpful I'm only too happy to help out.
View attachment 136809