Reply to thread

[USER=13908]@peter2[/USER] 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).

[USER=13908]@peter2[/USER] 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.

[ATTACH=full]136809[/ATTACH]