camopaint0707
camopaint0707 HalfDork
9/23/24 10:29 a.m.

So Mid Atlantic Car Fest is in two weeks.  Previously I just used a google excel sheet to input timing, add it all up and that was that.  This year we are moving to points.  So my plan is, I'll manually input the times from each event.  So like the tnia first place is 20 points, second 19, etc.  Then same for the drag racing.  Like fastest time is 20 points etc.  Then ideally, I'd like to use excel to sort by highest overall points.  I guess what I can't figure out, is when I change the points a person won, it won't automatically adjust the overall points then into a ascending order.  If that makes sense.

Scott_H
Scott_H Reader
9/23/24 2:51 p.m.

Try searching for Dynamic Sorting".  Here is one way to do it.

https://www.youtube.com/watch?v=x1qZAzRkIV0

You'll need to log in to post.

Our Preferred Partners
dmB1itcESwITFGrk1DVAmnigMP3aXFsvvXKwFlQp3SX5zo1RaoGxXSitP9pSmeF6