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
marcreid
7 - Meteor
10-14-2017
12:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Took the long way round on this one..
hoheusle
6 - Meteoroid
10-20-2017
01:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Spoiler
I first used the record ID tool, but that doesn't work since you need to restart at 1 for a new file name. Within the Multi-Row Formula, this can be quickly done by grouping by FileName. Helps simplify the expression.
JoshKushner
12 - Quasar
10-27-2017
05:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
dominiklz
8 - Asteroid
10-31-2017
01:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
930realm
7 - Meteor
11-03-2017
11:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Had to change the file format to xlsx because I kept getting an error trying to open the xls. I thought I would be able to use the sql to bring back the fields, but it looks like I can only bring in sheet names and named ranges. All in all it looks like my solution is similar to others.
dsmdavid
11 - Bolide
11-20-2017
12:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
samN
10 - Fireball
11-23-2017
06:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AT_12
7 - Meteor
11-23-2017
07:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
edorlando07
7 - Meteor
11-26-2017
04:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
edorlando07
7 - Meteor
11-26-2017
04:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator