VRC LRS HS teams, divisions and rankings
VRC LRS MS teams, divisions and rankings
Rest in peace HS Jupiter division
Some data may not be accurate as some teams have no skills score at all. Excel vlookup cannot detect such situation.
I though that the division assignments were suppose to be by skill? Why on earth is 4478D with a score of 252 in Jupiter when the next highest score is 166?
that’s because 4478D had no score at all. excel calculation error. lol
put a 0 as your fourth arguement. That will make it come back with an #N/A and then use iferror to catch it.
good call! thanks. worksheet is now fixed.
bug fixed. check again.
Random question, but what is the “Post Code” field in your spreadsheet?
Some of them are quite clearly not postal codes.
Oh. Retrieved postal code/zip code from robotevents. Lol
Some of them come from other countries