{"id":634,"date":"2022-02-09T09:03:16","date_gmt":"2022-02-09T15:03:16","guid":{"rendered":"http:\/\/www.perceptivepetal.com\/wordpress\/?p=634"},"modified":"2022-02-09T09:15:18","modified_gmt":"2022-02-09T15:15:18","slug":"unique-and-arrayformula-make-counting-and-occurrence-in-a-column-a-breeze","status":"publish","type":"post","link":"https:\/\/www.perceptivepetal.com\/wordpress\/unique-and-arrayformula-make-counting-and-occurrence-in-a-column-a-breeze\/","title":{"rendered":"Unique and ArrayFormula Make Counting and Occurrence in a Column a Breeze!"},"content":{"rendered":"<p>How many are on each bus?\u00a0<\/p>\n<p>In a Google Form, I am collecting bus information with three options to choose from.\u00a0 I needed a way to count the number of occurrences of each, so I know how many are on each bus.\u00a0 Following the instructions found here:\u00a0<a href=\"https:\/\/www.extendoffice.com\/documents\/excel\/4707-google-sheets-count-number-of-occurrence.html,\">https:\/\/www.extendoffice.com\/documents\/excel\/4707-google-sheets-count-number-of-occurrence.html,<\/a>\u00a0I was able to easily accomplish it!\u00a0 I did grab my data from another sheet in the workbook than the Dashboard sheet I was putting this on.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How many are on each bus?\u00a0 In a Google Form, I am collecting bus information with three options to choose from.\u00a0 I needed a way to count the number of occurrences of each, so I know how many are on each bus.\u00a0 Following the instructions found here:\u00a0https:\/\/www.extendoffice.com\/documents\/excel\/4707-google-sheets-count-number-of-occurrence.html,\u00a0I was able to easily accomplish it!\u00a0 I did&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[118],"tags":[],"_links":{"self":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/634"}],"collection":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/comments?post=634"}],"version-history":[{"count":2,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/634\/revisions"}],"predecessor-version":[{"id":636,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/634\/revisions\/636"}],"wp:attachment":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/media?parent=634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/categories?post=634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/tags?post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}