Monday, March 23, 2015

yogi_Select Specified Number Of Card Nos and Corresponding Characters for 'X-Men Card Dice Game'

                                           Google Spreadsheet   Post  #1928
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Mar 23, 2015
question by Kaleb Captain:!category-topic/docs/spreadsheets/_DhDazbNfro
How to create list of unique values from range (column) and then display assoc. data (row)
My spreadsheet:

I attempting to create an automated way to draft random characters in an X-Men card/dice game.  You can see my headway on sheet 'RandomCharacters' where I generate a list of random characters.  However, multiple characters exist for each character type (see below).

Sample Data:
Card #CharacterName
1AngelAir Transport
63AngelFlying High
64Ant-ManPym Particles
95Ant-ManThe Insect World
22WolverineThe Best There Is
23WolverineNot Very Nice
61X-23Scent of Murder
121X-23Killing Machine

So now on sheet 'UniqueCharacters' I am trying to constrain the list to unique character types (column B). For example, if "Angel - Air Transport" has been drafted then I want "Angel - Inspiring" as well as any other "Angel" characters to be excluded.  

Current Output (undesirable duplicate characters):
Angel - Air Transport (1)
Angel - Inpiring (2)
Black Panther - Wakanda Chief (38)
Cable - Time Traveler (99)
Captain America - "Follow Me!" (69)
Captain America - Special Ops (40)
Cyclops - Optic Blast (4)
Falcon - Samuel Wilson (42)

Any help would be greatly appreciated!  Be forewarned, I am much more a script kitty than a mathematician, so thanks for your patience as well.

- KC