•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
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]
Want to read more?
Check out the full article on the original site
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