'Excel: Finding matching criteria from 2 distinct columns?

enter image description here

I'm analyzing some data for a program that I'm currently in. Sorry if the question is vague, but bear with me.

I'm trying to analyze the contents/criteria of column B "rideable_type" and column M "member_casual", indicated by the black squares.

Basically, what I'm trying to do is this: I'm trying to figure out if there is a correlation between the bikes that people ride, and the member affiliation that they identify with. An easier way to explain this could be: "Do members ride classic_bikes more than electric bikes? In other words, does member affiliation correlate to the type of bikes that they ride?

Any help is appreciated.

Thank you.

excel excel-formula

Solution 1:^[1]

Or you can try Pivot table, to present them in more powerful way, and more dimensions too:

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	navafolk

'Excel: Finding matching criteria from 2 distinct columns?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]