Google/スプレットシート/クエリ
提供: 初心者エンジニアの簡易メモ
集計
=query(A2:J10000,"select E,count(E) group by E",1)
ソート
=query(A2:J10000,"select E order by E desc",1)
=query(A2:J10000,"select E,count(E) group by E",1)
=query(A2:J10000,"select E order by E desc",1)
|
|
