Search found 3 matches

by chriswilliams
Thu Jun 02, 2011 8:30 pm
Forum: Help Desk
Topic: Player and Group Loot auto population
Replies: 5
Views: 7339

Re: Player and Group Loot auto population

Leveraging search and vlookup you can return a list of all treasure belonging to PCx including duplicates. I have to do it in writing sheets for tracking hardware in multiple regions for work. You can also run filter extracts to create list dependencies on names fields.
by chriswilliams
Thu Jun 02, 2011 7:59 pm
Forum: Help Desk
Topic: Player and Group Loot auto population
Replies: 5
Views: 7339

Re: Player and Group Loot auto population

vlookup will do the trick. This greatly reduces the usefulness of this tool. Another way of doing this would be pivot tables, but because the sheet is locked, there's no modifications that can be done.
by chriswilliams
Thu Jun 02, 2011 6:50 pm
Forum: Help Desk
Topic: Player and Group Loot auto population
Replies: 5
Views: 7339

Player and Group Loot auto population

I was hoping that when you entered loot on the treasure tab and assigned it, that the Player's Loot and Group tabs would be automatically populated. This does not appear to be the case for either Excel 2011 or Excel 2010. Can someone confirm for me if this expected but not realized behavior is by de...

Go to advanced search