I have an array with text in the first column and numbers in the next four, the text values repeat. I want to make a summary sheet. So I want a formula that searches for text in the defined array, then counts a number from a given column if the row matches.
I want a summary sheet that would look like this:
Basically find all matches of name and return the number next to it (well my data it is actually the 3rd column I want)
from this example data:
I want a summary sheet that would look like this:
Dave | 5 |
Steve | 2 |
Larry | 1 |
Basically find all matches of name and return the number next to it (well my data it is actually the 3rd column I want)
from this example data:
Dave | 3 |
Dave | 2 |
Steve | 2 |
Larry | 1 |