+- NordInvasion Forum (https://forum.nordinvasion.com)
+-- Forum: Discussions (https://forum.nordinvasion.com/forumdisplay.php?fid=7)
+--- Forum: Community Discussion & Engagement (https://forum.nordinvasion.com/forumdisplay.php?fid=14)
+--- Thread: The Great List of Swadian Heroes (/showthread.php?tid=19971)
Re: The Great List of Swadian Heroes - Malong - 01-09-2015
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))Re: The Great List of Swadian Heroes - Sir_Mike - 05-09-2015
House Tag: Sarrallia
Character Name: Orion_Sarrallia
Hero Class:Chosen Marksman
Re: The Great List of Swadian Heroes - bluzark - 05-09-2015
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
Re: The Great List of Swadian Heroes - Deer - 05-09-2015
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
Re: The Great List of Swadian Heroes - Surkan - 05-09-2015
House Tag: CC
Character Name: PewPewPew
Hero Class: Warden
Re: The Great List of Swadian Heroes - Master - 19-09-2015
House Tag: Disciple_
Character Name: Disciple_Master
Hero Class: Warden
Re: The Great List of Swadian Heroes - Sargent Q - 19-09-2015
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.
Re: The Great List of Swadian Heroes - Dagon - 11-10-2015
House Tag: SPQR
Character Name: Dagon
Hero Class: Zweihander
Re: The Great List of Swadian Heroes - Consweber - 11-10-2015
FORM NEEDED:
House Tag: FV_
Character Name: consAweber
Hero Class: sentinal
Re: The Great List of Swadian Heroes - Sigolo - 11-10-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