afriditigr
New Member
- Joined
- Feb 23, 2012
- Messages
- 3
Hi,
I have a long list with dates from google in the first comumn,
and in my third column I have dates from our database where customers made a registration in our website.
What I want to do in the second column(count-data) is : given the date in the first column, for example 12/7/2011 go to the third column and count the cells which have the dame date 12/7/2011, and then appear at the second column the counts.
I did it manually so far, and I failed to use countif and vlookup.
Do you have any suggestions,
Thank you
GOOGLE count-data DATABASE
12/7/2011 2 12/7/11
12/8/2011 1 12/7/11
12/9/2011 1 12/8/11
12/10/2011 2 12/9/11
12/11/2011 12/10/11
12/12/2011 12/10/11
12/13/11 12/12/11
12/14/11 12/12/11
12/15/11 12/12/11
12/16/11 12/12/11
12/17/11 12/12/11
12/18/11 12/13/11
12/19/11 12/13/11
12/20/11 12/13/11
12/21/11 12/14/11
12/22/11 12/15/11
12/23/11 12/17/11
12/24/11 12/24/11
12/25/11 12/24/11
12/26/11 12/25/11
12/27/11 12/25/11
12/28/11 12/25/11
12/29/11 12/27/11
12/30/11 1/4/12
12/31/11 1/4/12
1/1/2012 1/4/12
1/2/2012 1/5/12
1/3/2012 1/5/12
1/4/2012 1/5/12
1/5/2012 1/5/12
1/6/2012 1/7/12
1/7/2012
I have a long list with dates from google in the first comumn,
and in my third column I have dates from our database where customers made a registration in our website.
What I want to do in the second column(count-data) is : given the date in the first column, for example 12/7/2011 go to the third column and count the cells which have the dame date 12/7/2011, and then appear at the second column the counts.
I did it manually so far, and I failed to use countif and vlookup.
Do you have any suggestions,
Thank you
GOOGLE count-data DATABASE
12/7/2011 2 12/7/11
12/8/2011 1 12/7/11
12/9/2011 1 12/8/11
12/10/2011 2 12/9/11
12/11/2011 12/10/11
12/12/2011 12/10/11
12/13/11 12/12/11
12/14/11 12/12/11
12/15/11 12/12/11
12/16/11 12/12/11
12/17/11 12/12/11
12/18/11 12/13/11
12/19/11 12/13/11
12/20/11 12/13/11
12/21/11 12/14/11
12/22/11 12/15/11
12/23/11 12/17/11
12/24/11 12/24/11
12/25/11 12/24/11
12/26/11 12/25/11
12/27/11 12/25/11
12/28/11 12/25/11
12/29/11 12/27/11
12/30/11 1/4/12
12/31/11 1/4/12
1/1/2012 1/4/12
1/2/2012 1/5/12
1/3/2012 1/5/12
1/4/2012 1/5/12
1/5/2012 1/5/12
1/6/2012 1/7/12
1/7/2012