Home > Net >  Query multiple columns of data in Google Sheets and count number occurrences
Query multiple columns of data in Google Sheets and count number occurrences

Time:01-30

I am trying to query two columns of data in Google Sheets and count how many times the values occur.

I have made a Google Sheets formula which works but only returns data in the first column.

=QUERY(QUERY({D2:D,E2:E}, "select Col1, count(Col1) group by Col1"), "select Col1, Col2 order by Col2 desc, Col1 limit 45", 0)

How can I query and count data from both columns together?

enter image description here

DESIRED RESULT

2.38 / 2

5.38 / 2

...

I have made a Google Sheet showing an example. This can be copied by going to File-Make a Copy

enter image description here

  • Related