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
smoskowitz
12 - Quasar
01-25-2019
12:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
WH
7 - Meteor
01-27-2019
06:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
1. 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
Thableaus
17 - Castor
01-28-2019
12:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sharathkumargurram1
7 - Meteor
01-28-2019
06:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sajeel_Kershi
8 - Asteroid
02-03-2019
05:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
GiuseppeC
Alteryx
02-05-2019
08:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
FeedMeData
8 - Asteroid
02-06-2019
07:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
TonyA
Alteryx Alumni (Retired)
02-08-2019
09:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hanykowska
11 - Bolide
02-10-2019
07:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JonathanAllenby
8 - Asteroid
02-11-2019
02:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator