Spreadsheetz
New Member
- Joined
- Jun 12, 2016
- Messages
- 22
Hello!
Hopefully this is an easy one.. I have a spreadsheet with a number of names in one column, and locations in another column. I'm hoping to find a formula that can tell me how many times the location shows up per person.
For example:
<tbody>
</tbody>
Is there a function to use that could quickly spit out something like this:
<tbody>
</tbody>
Just a count of how many times the value in the location column occurs per name.
Thanks in advance!!
Hopefully this is an easy one.. I have a spreadsheet with a number of names in one column, and locations in another column. I'm hoping to find a formula that can tell me how many times the location shows up per person.
For example:
location | name |
Calfornia | Jeff |
Maine | Mary |
California | Jeff |
Michigan | Mary |
Michigan | Mary |
Wyoming | Jeff |
<tbody>
</tbody>
Is there a function to use that could quickly spit out something like this:
location | name | count |
california | jeff | 2 california, 1 wyoming |
maine | mary | 2 michigan, 1 maine |
california | jeff | 2 california, 1 wyoming |
Michigan | Mary | 2 michigan, 1 maine |
Michigan | mary | 2 michigan, 1 maine |
Wyoming | Jeff | 2 california, 1 wyoming |
<tbody>
</tbody>
Just a count of how many times the value in the location column occurs per name.
Thanks in advance!!