Here's my solution.
Edit: And yes, having looked at others I'm kicking myself for not doing the selection with a single formula tool - doh!
Search
Close
Free Trial Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA- Community
- :
- Community
- :
- Learn
- :
- Academy
- :
- Challenges & Quests
- :
- Weekly Challenges
- :
- Challenge #19: Excel Record Locator
Labels
- Advanced 290
- Apps 25
- Basic 150
- Calgary 1
- Core 143
- Data Analysis 185
- Data Cleansing 6
- Data Investigation 7
- Data Parsing 12
- Data Preparation 220
- Developer 35
- Difficult 78
- Expert 16
- Foundation 13
- Interface 39
- Intermediate 257
- Join 209
- Macros 55
- Parse 140
- Predictive 20
- Predictive Analysis 14
- Preparation 272
- Reporting 54
- Reporting and Visualization 17
- Spatial 60
- Spatial Analysis 53
- Time Series 1
- Transform 223
- « Previous « Previous
- Next » Next »
