My Problem
I have built a count query that returns the most common elements from column H in the final
sheet:
=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:
HAVING COUNT(H)>1
However, this fails with #VALUE!
on Google Sheets.
My Question
How can I filter out query elements based on their count?