Google Spreadsheet Post #1928
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Mar 23, 2015
question by Kaleb Captain:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/_DhDazbNfro
How to create list of unique values from range (column) and then display assoc. data (row)
My spreadsheet:
https://docs.google.com/
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 # | Character | Name |
| 1 | Angel | Air Transport |
| 2 | Angel | Inpiring |
| 3 | Angel | Superhero |
| 63 | Angel | Flying High |
| 35 | Ant-Man | Biophysicist |
| 64 | Ant-Man | Pym Particles |
| 95 | Ant-Man | The Insect World |
| ... | ... | ... |
| 22 | Wolverine | The Best There Is |
| 23 | Wolverine | Not Very Nice |
| 24 | Wolverine | Superhero |
| 92 | Wolverine | Antihero |
| 61 | X-23 | Scent of Murder |
| 93 | X-23 | Assasin |
| 121 | X-23 | Killing 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
-----------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment