I'm looking for some help in counting the number of times a frequent data point shows up in different line items.
Here's an idea of what I have:
Col A Col B
x Ford
x Ford
y GMC
y GMC
z Ford
z Ford
yy GMC
xx Ford
xx Ford
zz Dodge
zz Dodge
a Dodge
a Dodge
a Dodge
dd GMC
b Ford
b Ford
c GMC
c GMC
d Dodge
I'm trying to count up the number of unique times (from Col A) Ford/GMC/Dodge show up so the results look like:
Ford 4
GMC 4
Dodge 3
I've gotten into some crazy arrays but can't wrap my brain around how to count this up correctly.
Thanks!
Bookmarks