Challenge #19: Excel Record Locator
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JesterOne
7 - Meteor
04-19-2021
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Maskell_Rascal
13 - Pulsar
04-20-2021
11:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
realdaniel1989
8 - Asteroid
04-23-2021
04:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
maicolpolvere
6 - Meteoroid
05-04-2021
12:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ENix
8 - Asteroid
05-10-2021
07:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
jtoboyle
6 - Meteoroid
05-11-2021
10:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is my solution for Challenge 19.
Thomas_W
8 - Asteroid
05-12-2021
03:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Erin
11 - Bolide
05-12-2021
08:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I wish I had seen and attempted this challenge 2 years ago! In my last role, we would often pull the latest saved file from a specific file folder using combo of the directory tool, sorts, filters, records IDs and dynamic input. But that was always inputting a single file. I rarely needed to input a whole bunch of identical files, and once did it manually because I'm a sucker. Glad those days are over!
Spoiler
Also, being stubborn, I tried to create the row with record ID as I haven't fallen in love with the multi-row formula tool that seems to be in every challenge. Guess what, didn't work for the additional files. So I used the all time fav multi-row formula tool after all. I learn by doing so these challenges are great for me!


RashedDS
8 - Asteroid
05-23-2021
05:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
apathetichell
20 - Arcturus
05-28-2021
03:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator