I am ranking answer for a form. and I came up with this formula

=ArrayFormula(QUERY({'LEADs oGV'!U:U,LEN('LEADs oGV'!U:U)},
 "select Col1, count(Col2) where Col2 > 0 group by Col1 order by count(Col2) desc limit 3",

The problem is that it does not count the number of blank answers in the given column! How can I do that without filling every single blank cell?

  • 1
    Can you share a sheet with us Brites and show us your expected outcome, so we can have a look? – Jacob Jan Tuinstra Jun 22 '17 at 7:28
  • docs.google.com/spreadsheets/d/… Here it is! The tables in "Publico oGV", takes input from "LEADs oGV", which is exported from my company's software – Brites Jun 22 '17 at 19:11

Maybe try:

=ArrayFormula(QUERY({'LEADs oGV'!U:U,LEN('LEADs oGV'!U:U)},
 "select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 4",0))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.