Hi,
I have 3 fields like name,date ,value.
Here date field contains date that date may be repeat for any times.I need sum of values based on date.
Please check the attached excel file.
data like this,,Date will repeat any number of times......
Name Date Value Result like this Date Sumof value
teat1 3/31/2012 1 3/31/2012 23
teat2 3/31/2012 1 4/1/2012 6
teat3 3/31/2012 1 4/2/2012 3
teat4 3/31/2012 1
teat5 3/31/2012 1
teat6 3/31/2012 1
teat7 3/31/2012 1
teat8 3/31/2012 1
teat9 3/31/2012 1
teat10 3/31/2012 1
teat11 3/31/2012 1
teat12 3/31/2012 1
teat13 3/31/2012 1
teat14 3/31/2012 1
teat15 3/31/2012 1
teat16 3/31/2012 1
teat17 3/31/2012 1
teat18 3/31/2012 1
teat19 3/31/2012 1
teat20 3/31/2012 1
teat21 3/31/2012 1
teat22 3/31/2012 1
teat23 3/31/2012 1
teat24 4/1/2012 1
teat25 4/1/2012 1
teat26 4/1/2012 1
teat27 4/1/2012 1
teat28 4/1/2012 1
teat29 4/1/2012 1
teat30 4/2/2012 1
teat31 4/2/2012 1
teat31 4/2/2012 1
Bookmarks