Posts: 1,907
Threads: 263
Joined: Jan 2012
I noticed the formula for the houses is causing a reference error. If you let the formula create the header row for you, something like this should work:
Code:
=ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(" ",'House Count'!A2:A)," ")&{"";""}),"select Col1, count(Col2) group by Col1 order by count(Col2) desc label Col1 'House', count(Col2) 'Heroes'",0))
Quote Board is on Discord (last updated 2023.09.07)
"When I feel bad, I read your quote board." - Corndog
Tofu: People call Tricksters racist, yet we have the most Muslim members of any house.
PCK: If Islam is a religion of peace, and Tricksters have the most Muslims, then is House of Tricksters the house of peace?
Falankos: I always knew that we were the good guys.
Posts: 18
Threads: 44
Joined: Jul 2012
House Tag: Sarrallia
Character Name: Orion_Sarrallia
Hero Class:Chosen Marksman
Check me out on youtube. Mrkillemall1983
Add me on steam for all your crafting needs.http://steamcommunity.com/profiles/76561198045053501/home
Posts: 347
Threads: 42
Joined: Aug 2014
House Tag: DB_
Character Name: DB_ZARK
Hero Class: Zweihander
House Tag: DB_
Character Name: DB_BLAZURK
Hero Class: Marauder
Old Character Name (if renamed): [UK]_BLUZARK
Old House Tag (if changing house): [UK]_
New House Tag: DB_
New Character Name: DB_BLUZARK
Hero Class: Warden
Old Character Name (if renamed): [UK]_BLUVARK
Old House Tag (if changing house): [UK]_
New House Tag: DB_
New Character Name: DB_KRAZULB
Hero Class: Master Peltast
Old Character Name (if renamed): [UK]_BLUXARK
Old House Tag (if changing house): [UK]_
New House Tag: DB_
New Character Name: DB_Dr_BLUZ
Hero Class: Pavise Champion
Posts: 373
Threads: 116
Joined: Aug 2012
New House Tag: LK
New Character Name: Deerheart
Hero Class: Royal Guard
fix tags for
New House Tag:LK
New Character Name: Furcifer
Hero Class: Warden
ew House Tag:LK
New Character Name: Eikthyrnir
Hero Class: Legionnaire
ew House Tag:LK
New Character Name: CerynianHind
Hero Class: Master Peltast
ew House Tag:LK
New Character Name: Hart_Or
Hero Class: Halberdier
ew House Tag:LK
New Character Name: Cernunnos
Hero Class: Pavise Champion
Characters:
Deerheart: Royal ShielDeer | Eikthyrnir: Antlered Legionnaire | Cernunnos: Pavise ShielDeer | CerynianHind: Master of Pelts | Hart_Or: HalberDeer | Furcifer: Warden of the Wood
Posts: 9
Threads: 1
Joined: Aug 2015
House Tag: CC
Character Name: PewPewPew
Hero Class: Warden
CC_gerhunkdiviza - lvl 52 Pikeman/Inf hybrid
CC_PewPewPew - lvl 52 Warden
CC_Surkan - lvl 39 Sharpshooter
Posts: 69
Threads: 65
Joined: Aug 2015
House Tag: Disciple_
Character Name: Disciple_Master
Hero Class: Warden
Posts: 864
Threads: 55
Joined: May 2014
Please add
House Tag: VM
Character Name: VM_Warmaster_Q
Hero Class: Legionnaire
House Tag: VM
Character Name: VM_Sargeant_Q_Archer
Hero Class: Sentinel.
Steam name: Sargeant Q
Posts: 65
Threads: 52
Joined: Aug 2014
House Tag: SPQR
Character Name: Dagon
Hero Class: Zweihander
Characters: Crafting:
Dagon - 52 Zweihander (Hero) Armorsmith Lvl 17
Dagon_II - 52 Chosen Marksman (Hero) Alchemist Lvl 18
Dagon_III - 32 Heavy Skirmisher (T3) Blacksmith Lvl 15
Dagon_IV - 33 Heavy Longbowman (T3) Support Lvl 15
Legendaries:
(Dates are in DD/MM/YYYY)
Bulwark of Swadia 04/10/2015
Posts: 71
Threads: 10
Joined: May 2014
FORM NEEDED:
House Tag: FV_
Character Name: consAweber
Hero Class: sentinal
Posts: 165
Threads: 27
Joined: Mar 2015
House Tag: SK_
Character Name: Sigolo2
Hero Class: Legionnaire
House Tag: SK_
Character Name: Sigolo3
Hero Class: Warden
House Tag: SK_
Character Name: Sigolo4
Hero Class: Master Peltast
![[Image: 5OL0wry.png]](https://i.imgur.com/5OL0wry.png)
![[Image: D7W32lN.jpg]](https://i.imgur.com/D7W32lN.jpg)