0

Here is my formula:

=QUERY('2021 Report'!E3:E76;"SELECT E, COUNT(E) GROUP BY E ORDER BY COUNT(E) DESC LABEL (E) 'COUNTRY'";0)

Here is the results

It's returning the count as header. I want just the numbers. Is there any way to remove this count header?

Bachian
  • 21
  • 1

1 Answers1

-1

Try (no headers)

=QUERY('2021 Report'!E3:E76,"SELECT E, COUNT(E) GROUP BY E ORDER BY COUNT(E) DESC label COUNT(E) ''",0)
Mike Steelson
  • 14,650
  • 2
  • 5
  • 20