- 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
2
Posted on 2/9/18 at 10:32 am to reddman
It's not like you have anything better to do.
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.
Page 1 of 1
Back to top
Follow TigerDroppings for LSU Football News