Forum Discussion
ABlea010
Jan 24, 2024Copper Contributor
What is the best way to pull and seperate data from a table? VLOOKUP? Anything better?
I have a table that shows a sports league's schedule and results. I want to pull data from that table for each team and then separate it between home and away for each team on separate sheets. What w...
HansVogelaar
Jan 24, 2024MVP
If you have Microsoft 365 or Office 2021, you can use the FILTER function
- ABlea010Jan 25, 2024Copper ContributorFILTER worked perfectly, thank you!