I have built a count query that returns the most common elements from column H in the
=QUERY(final!H2:H,"SELECT H, COUNT(H) GROUP BY H ORDER BY COUNT(H) DESC")
I would like to filter out elements that appear only once. In traditional SQL I would add:
However, this fails with
#VALUE! on Google Sheets.
How can I filter out query elements based on their count?