SandraStace
New Member
- Joined
- Nov 28, 2018
- Messages
- 4
I am trying to pull information from sheet "data" into sheet "results" I need to know how many times a person's name was listed on the data sheet. I need it to separate out according to the date as well as the person's name. A formula is preferred, I need the number of times "ttest" shows up in the month of March to be inputted into B2.
Results Tab
<tbody>
</tbody>
Data Tab
<tbody>
</tbody>
Thank you
Results Tab
Mar-18 | |
ttest | |
ttest2 |
<tbody>
</tbody>
Data Tab
ttest | Mar2018 | act | l# | type | nm | scr | cust | cust2 | coapp | # | 3/25/18 | ln | test | pr | src | ex | stat |
ttest2 | Mar2018 | act | l# | type | nm | scr | cust | cust2 | coapp | # | 3/30/18 | ln | test | pr | src | ex | stat |
ttest | Mar2018 | act | l# | type | nm | scr | cust | cust2 | coapp | # | 3/15/18 | ln | test | pr | src | ex | stat |
<tbody>
</tbody>
Thank you