•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to add different cells based on people's names change columns
Our take
Managing game stats in Excel can be both rewarding and challenging. If you want to automate updates for your monthly stats based on player participation, you can use functions like `SUMIF` or `INDEX-MATCH` to dynamically reference names and their corresponding scores, even when their positions shift. Additionally, assigning point values for rankings can be achieved with a simple scoring system that tallies results at the end of each month. This approach will help you maintain an objective overview of player performance.
We play a card game and lunch and we've started to keep track of stats in excel, I'm pretty happy with how I've made it so far but there are 2 things I haven't figured out on my own.
- How to make the monthly stats update after each game, I've been copying a template downwards so all 5-8 players are all in the same columns but sometimes someone won't play or won't be at work so people's names move around, if i could tell excel to go to the "wrongs" row under this person's name, that would be good but I don't know how.
- We need a way to assign a value to 1st through 8th and then at the end of the month, we have an objective way to say who did the best that month.
I added a couple of pictures below just to help visualize sort of.
Thanks.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Proper maintenance of game activity tableI'm part of a team of a rather small hobby game that we've been running for many years now. We've been running simple activity summaries in hours spent like this monthly, ever since beginning in April 2017. They simply go like this: GM Matt - 65.7h M Aiden - 54.3h K Hawk - 32.1h K Tell - 30.0h M Poe - 27.6h T Tribux - 25.4h M Vair - 24.5h K Rodian - 23.3h K Eventide - 20.1h T Crab - 14.4h M Voss- 14.3h M Teir - 9.1h M Vallin - 4.4h T Forrte - 0.5h They're posted monthly so there are similar tables for May 2017, June 2017 and so forth up to April 2026. I want to start storing them all in Excel, this is what I did so far: https://preview.redd.it/n9oem7xh2zug1.png?width=1529&format=png&auto=webp&s=95855988839af802d4d6830df3996943eecdc85f The sum part for each year is simply: =SUM(D3:L3) and so on. Then there's a final column "ALLTIME" where I sum everything to the left except the columns with yearly sums. This works so far, but I'm wondering if there's a better approach that's gonna be more comfortable in the future if I want to extract more data. I have zero experience with data management and Excel, this is what came intuitively to me, but I want to know if there isn't something that will bite me in the ass in the future. submitted by /u/Informal-Ordinary387 [link] [comments]
- How to capture 1st and 2nd place, accounting for tiesA B C D Mike 1 2 4 7 Fred 4 1 4 6 George 3 6 4 6 Julie 7 3 6 So I'm trying to "automate" a spreadsheet to accompany a board game. I need to track who's in first and second place, while accounting for ties... so for each of the columns, I'd need the following results: A: A 1 Fred 2 George B: B 1 Julie 2 George C: C 1 Fred, George, Mike 2 D: D 1 Mike 2 Julie, George, Fred All table formatting by ExcelToReddit All of my original data is captured in a single grid (like in my example), and I'm breaking out each "column" into a separate grid, currently sorted by that column value... basically, I just need to figure out how to combine "duplicate" values (all of the first place owners together, all of the second place owners together) to account for ties. The order of the names within the placements is immaterial (doesn't necessarily need to be alpha within the specific rank). In the case of a tie for first, there would be no second place. There will be another column on the right to show the "payout" for each placement, but I'm pretty sure I can figure out how to get the payout correct once I've got the correct number of names for each place. Running 365 on Windows, if that changes anything. Any thoughts? submitted by /u/Cr4nkY4nk3r [link] [comments]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#row zero#financial modeling with spreadsheets#cloud-based spreadsheet applications#Excel#monthly stats#card game#track stats#template#players#assign value#objective#1st through 8th#update stats#names change#cells#visualize