28-02-2014, 12:15 AM
(28-02-2014, 12:11 AM)Malong link Wrote: It looks like the RG and Legionnaire lists are the same. And I see players in my house missing from certain lists (e.g. Evildan and Malong from Wardens, Eve from Rangers, etc), and others being counted as in multiple houses (numbers don't add up).[/quote]
If you want help making this a Google doc leveraging the API to aggregate, let me know. For example, to list classes by popularity, it's:
Code:=ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(" ",Heroes!C2:C)," ")&{"";""}),"select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 12 label Col1 'Class', count(Col2) 'Number'",0))
[quote author=Buttercup link=topic=23654.msg167956#msg167956 date=1393537356]
[glow=black,1,150]Royal Guards[/glow]
[glow=black,1,150]Legionnaire[/glow]
[/spoiler]
![[+]](/images/collapse_collapsed.png "[+]")
SpoilerKip was kind enough to do that for me, and ill fix my mistake, but thank you for the offer.