Imagine these two columns <http://i.imgur.com/WNdY84b.png>
I'd like to do something like this (MySQL): SELECT CONCAT(A, ' ', B) AS name, COUNT(*) AS count GROUP BY A, B ORDER BY count DESC I.e., I want to count the number of unique combinations, and order them by the most frequent one. The result would look something like this: name - count 3 2 - 531 1 3 - 492 2 5 - 327 etc How would I achieve this in a google spreadsheet document? -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
