- 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
re: FSBDL 2018 - MWG is your Champion
Posted on 2/9/18 at 10:39 am to reddman
Posted on 2/9/18 at 10:39 am to reddman
quote:
This is gonna take some time because i have to assign the players to their teams doing it this way, but frick it.
1. Export players from Fantrax
2. Export players from Steamer
3. TRIM last name from Fantrax bc they're tards who decided to do Lastname, Firstname
4. Do the same for the Steamer sheet
5. Power Query to join Lastnames between the two tables bringing over team owner from the Fantrax sheet into your Steamer sheet
6. If you don't have Power Query try VLOOKUP and HLOOKUP functions.
7. Save an hour or two of your time.
Posted on 2/9/18 at 10:50 am to swamie
quote:
7. Save an hour or two of your time.
Except for the fact that he will spend an hour googling what power query is, I don't think Redd is a power excel user.
Back to top
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)