- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Question: Win/Loss
Posted on 9/14/22 at 2:30 pm
Posted on 9/14/22 at 2:30 pm
I am a high school soccer coach, and I put together an excel sheet that has the schedule of each team, and how many games each team has won, loss and tied.
Obviously it's easy to just look at the sum at the bottom to get the number of wins, losses and ties - and then type those in manually to an "overall record" column.
However, I was wondering if there was a way that I can combine those values into one cell? For instance if a team has 6 wins, 2 losses and 1 tie, their record would be 6-2-1. I have a "sum" function at the bottom of each column to calculate those, but I want those values to populate into a cell to get me the (win)-(loss)-(tie) without me having to type them in manually. Is this possible?
Obviously it's easy to just look at the sum at the bottom to get the number of wins, losses and ties - and then type those in manually to an "overall record" column.
However, I was wondering if there was a way that I can combine those values into one cell? For instance if a team has 6 wins, 2 losses and 1 tie, their record would be 6-2-1. I have a "sum" function at the bottom of each column to calculate those, but I want those values to populate into a cell to get me the (win)-(loss)-(tie) without me having to type them in manually. Is this possible?
3
Posted on 9/14/22 at 2:54 pm to lovethetigers7
Lets say that the total wins cell is A1, losses is B1 and ties is C1.
=concatenate(A1,"-",B1,"-",C1)
=concatenate(A1,"-",B1,"-",C1)
Posted on 9/14/22 at 3:30 pm to lovethetigers7
or you could simply use =a1&"-"&b1&"-"&c1
Posted on 9/14/22 at 4:48 pm to lovethetigers7
That's a fairly easy task if you regularly use excel, if for some reason you just need to do something occasionally and don't know how to do it this bot is great.
LINK / Excelformulabot
LINK / Excelformulabot
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News