Forum Discussion
Need help with Formula to help place campers into classes based on top 5 choices selected
OK, see attached file:
- Formatted your data as Table
- Added "ID" as 1st column header
- Put together 2 Get & Transform (aka Power Query) queries
- PEG: What I earlier shared
- Other Choices: Choices 4 & 5
With your data up to date in the Table (currently in sheet 'report (46)'),
- Switch to sheet 'PEGs'
- In Excel Data tab > Refresh All (takes a couple of secs.)
Any question let me know
OK, see attached file:
- Formatted your data as Table
- Added "ID" as 1st column header
- Put together 2 Get & Transform (aka Power Query) queries
- PEG: What I earlier shared
- Other Choices: Choices 4 & 5
With your data up to date in the Table (currently in sheet 'report (46)'),
- Switch to sheet 'PEGs'
- In Excel Data tab > Refresh All (takes a couple of secs.)
Any question let me know
You're welcome, always glad to help
Next time(s), please don't miss the Mark as response link (at the bottom of each reply you get on this site) - This helps people who Search - Thanks
- This is phenomenal - thank you so much!!!