- 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: Excel Help - Suggestions
Posted on 4/23/24 at 10:36 am to RoyalWe
Posted on 4/23/24 at 10:36 am to RoyalWe
quote:
Power Query is the easist way I know to do this.
This was the method I chose, and it worked perfectly. Never had used the tool before but once I was able to get the first sheet transformed correctly it went pretty smooth. I created a second sheet in the workbook for my formulas, created a formula array to identify unique values and then sumifs the rest of the columns. Once that workbook was completed, I just performed the same transformations on the next one, copied my formula sheet, and updated the formulas. Took about an hour and half all in.
I appreciate the assistance.
Popular
Back to top
Follow TigerDroppings for LSU Football News