Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA1. Use multi-row to create Row Index
2. How to get a specific cell from excel sheet
2.1 transpose and locate the cell by row&column index, then cross-tab
2.2 use formula to set the unwanted cells in same row to null, then use summarize to get the maximum or only number in that row