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
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Mar-18[/TD]
[/TR]
[TR]
[TD]ttest[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ttest2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Data Tab
[TABLE="width: 500"]
<tbody>[TR]
[TD]ttest[/TD]
[TD]Mar2018[/TD]
[TD]act[/TD]
[TD]l#[/TD]
[TD]type[/TD]
[TD]nm[/TD]
[TD]scr[/TD]
[TD]cust[/TD]
[TD]cust2[/TD]
[TD]coapp[/TD]
[TD]#[/TD]
[TD]3/25/18[/TD]
[TD]ln[/TD]
[TD]test[/TD]
[TD]pr[/TD]
[TD]src[/TD]
[TD]ex[/TD]
[TD]stat[/TD]
[/TR]
[TR]
[TD]ttest2[/TD]
[TD]Mar2018[/TD]
[TD]act[/TD]
[TD]l#[/TD]
[TD]type[/TD]
[TD]nm[/TD]
[TD]scr[/TD]
[TD]cust[/TD]
[TD]cust2[/TD]
[TD]coapp[/TD]
[TD]#[/TD]
[TD]3/30/18[/TD]
[TD]ln[/TD]
[TD]test[/TD]
[TD]pr[/TD]
[TD]src[/TD]
[TD]ex[/TD]
[TD]stat[/TD]
[/TR]
[TR]
[TD]ttest[/TD]
[TD]Mar2018[/TD]
[TD]act[/TD]
[TD]l#[/TD]
[TD]type[/TD]
[TD]nm[/TD]
[TD]scr[/TD]
[TD]cust[/TD]
[TD]cust2[/TD]
[TD]coapp[/TD]
[TD]#[/TD]
[TD]3/15/18[/TD]
[TD]ln[/TD]
[TD]test[/TD]
[TD]pr[/TD]
[TD]src[/TD]
[TD]ex[/TD]
[TD]stat[/TD]
[/TR]
</tbody>[/TABLE]
Thank you
Results Tab
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Mar-18[/TD]
[/TR]
[TR]
[TD]ttest[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ttest2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Data Tab
[TABLE="width: 500"]
<tbody>[TR]
[TD]ttest[/TD]
[TD]Mar2018[/TD]
[TD]act[/TD]
[TD]l#[/TD]
[TD]type[/TD]
[TD]nm[/TD]
[TD]scr[/TD]
[TD]cust[/TD]
[TD]cust2[/TD]
[TD]coapp[/TD]
[TD]#[/TD]
[TD]3/25/18[/TD]
[TD]ln[/TD]
[TD]test[/TD]
[TD]pr[/TD]
[TD]src[/TD]
[TD]ex[/TD]
[TD]stat[/TD]
[/TR]
[TR]
[TD]ttest2[/TD]
[TD]Mar2018[/TD]
[TD]act[/TD]
[TD]l#[/TD]
[TD]type[/TD]
[TD]nm[/TD]
[TD]scr[/TD]
[TD]cust[/TD]
[TD]cust2[/TD]
[TD]coapp[/TD]
[TD]#[/TD]
[TD]3/30/18[/TD]
[TD]ln[/TD]
[TD]test[/TD]
[TD]pr[/TD]
[TD]src[/TD]
[TD]ex[/TD]
[TD]stat[/TD]
[/TR]
[TR]
[TD]ttest[/TD]
[TD]Mar2018[/TD]
[TD]act[/TD]
[TD]l#[/TD]
[TD]type[/TD]
[TD]nm[/TD]
[TD]scr[/TD]
[TD]cust[/TD]
[TD]cust2[/TD]
[TD]coapp[/TD]
[TD]#[/TD]
[TD]3/15/18[/TD]
[TD]ln[/TD]
[TD]test[/TD]
[TD]pr[/TD]
[TD]src[/TD]
[TD]ex[/TD]
[TD]stat[/TD]
[/TR]
</tbody>[/TABLE]
Thank you