Sport Stats - How to Format

[larinda4]

Good morning,

I'm making a spreadsheet to keep track of our leagues win/losses and stats. However, I think I'm formatting it incorrectly? The problem I'm having is if I try to filter it by home team, it won't show me the the same team when they're the visiting team.

ex. I want to see all of Norwood #2 matches but it won't show me if they're a visiting team.

Does anyone have a recommendation on how I should format this so I'm able to see a team whether they're home or visitor?

 

[Joe4]

One way is to use the new Filter function in a different place (off to the right of your current data or on another sheet).

Your formula would look something like this:

=VSTACK(FILTER(A:W,B:B="Norwood #3",""),FILTER(A:W,R:R="Norwood #3",""))

 

[larinda4]

One way is to use the new Filter function in a different place (off to the right of your current data or on another sheet).

Your formula would look something like this:

=VSTACK(FILTER(A:W,B:B="Norwood #3",""),FILTER(A:W,R:R="Norwood #3",""))

I'll try it out! Thanks Joe!

 

[larinda4]

One way is to use the new Filter function in a different place (off to the right of your current data or on another sheet).

Your formula would look something like this:

=VSTACK(FILTER(A:W,B:B="Norwood #3",""),FILTER(A:W,R:R="Norwood #3",""))

It worked! Is there any way to maintain the data in order of date though?

Or create "to" and "from" cells to input the dates and it only pulls data between that?

Thanks for all your help, Joe!

 

[Joe4]

Try this:

=FILTER(A:W,(B:B="Norwood #3")+(R:R="Norwood #3"),"")

 

[larinda4]

Try this:

=FILTER(A:W,(B:B="Norwood #3")+(R:R="Norwood #3"),"")

I'm not sure if I should start a new thread for this or if you could help me through here. If I need to start a new thread, please let me know and I will do so.

I'll try to explain this as best as I can:

I want to stack information now based on player. I have my player name is cell D1 and I want it to pull from either home or away based on the player name in D1. I want it to show Player Name, Handicap, Total, Win/Loss but it doesn't need to show the opponent.

For example, if the player was home, it would take columns C:G of that row and create a new list off to the side. If they were away, it would take columns S:W of that row and add it to the created list off to the side.

I've been racking my brain trying to think of a formula for this but now I'm thinking maybe I'd need to create a code?

 

[Joe4]

I'm not sure if I should start a new thread for this or if you could help me through here. If I need to start a new thread, please let me know and I will do so.

I'll try to explain this as best as I can:

I want to stack information now based on player. I have my player name is cell D1 and I want it to pull from either home or away based on the player name in D1. I want it to show Player Name, Handicap, Total, Win/Loss but it doesn't need to show the opponent.

For example, if the player was home, it would take columns C:G of that row and create a new list off to the side. If they were away, it would take columns S:W of that row and add it to the created list off to the side.

I've been racking my brain trying to think of a formula for this but now I'm thinking maybe I'd need to create a code?

It would be best to start a new thread, and to show your data, like you did in your first post in this thread.