Count Unique Words in Table Array
I have a table that is populated by rows of unique trucks hauling material in and out on any given day on any given job site. Multiple trucks (rows) will be created for the same date and job. The keys for these rows are currently uniquie ID’s. Multiple jobs will be logging multiple trucks on any given day. I need to count all of the materials hauled by one or more trucks for any given ‘Job - Date’. The goal is to count how many loads of concrete, or other materials, are used. There is a set enum list of material types to choose from so I simply need to report the counts of these materials.
I am leaning toward writing sheet expressions to report on a separate sheet (this is a challenge by itself) but want to see if any of you have any better ideas? Thanks in advance.
Example data below: