Hi All,
I have data for my team I have been able to retrieve data wise it using the sumproduct formula however now I am trying to capture this data for an entire month. I have tried several suggestion however had no success. Please advise.
Associate ID Date Updates
@B0814 Monday, October 01, 2012 0
@C2942 Monday, October 01, 2012 194
@D6400 Monday, October 01, 2012 15
@E4063 Monday, October 01, 2012 44
@E9539 Monday, October 01, 2012 58
@B0814 Tuesday, October 02, 2012 0
@C2942 Tuesday, October 02, 2012 0
@D6400 Tuesday, October 02, 2012 101
@E4063 Tuesday, October 02, 2012 40
@E9539 Tuesday, October 02, 2012 55
@B0814 Wednesday, October 03, 2012 0
@C2942 Wednesday, October 03, 2012 249
@D6400 Wednesday, October 03, 2012 210
@E4063 Wednesday, October 03, 2012 247
@E9539 Wednesday, October 03, 2012 153
@B0814 Thursday, October 04, 2012 0
@C2942 Thursday, October 04, 2012 127
@D6400 Thursday, October 04, 2012 66
@E4063 Thursday, October 04, 2012 137
@E9539 Thursday, October 04, 2012 29
I am trying to club all the dates when I select the month so that I get the complete data
Bookmarks