01-09-2015, 05:37 PM
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))
Voted Friendliest NordInvasion Player
Quote Board is on Discord (last updated 2025.02.02)
"When I feel bad, I read your quote board." - Corndog
Nka: You’re playing it smart, always [using] logic, and they get pissed.
Kaasovic: God, this guy is unbeatable. I feel defeated in every verbal argument we end up in. Good job, Sir.
Odi: Hasn’t [PCK beaten] the game at this point?
Quote Board is on Discord (last updated 2025.02.02)
"When I feel bad, I read your quote board." - Corndog
Nka: You’re playing it smart, always [using] logic, and they get pissed.
Kaasovic: God, this guy is unbeatable. I feel defeated in every verbal argument we end up in. Good job, Sir.
Odi: Hasn’t [PCK beaten] the game at this point?