"Jacob Skaria" wrote:

Forgot to mention to selection the date column only

DataFilterAdvanced FilterSelect Copy to another location..Select the date
column...

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Put headers for your data. Use advanced filter to generate unique records to
say Col D

DataFilterAdvanced FilterSelect Copy to another location..Select the list
range, Mention 'copy to' as (say cell D1). Check "Unique Records only'..OK
In E2 use the below formula and copy that down
=SUMIF(A:A,D2,B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Nigel P" wrote:

I would like to summarise data by date for example
A1 B1 - Date, Value
1/2/9 10
1/2/9 12
2/2/9 34
3/2/9 27
4/2/9 56

with results in another range of cells:
1/2/9 22
2/2/9 34
3/2/9 27
4/2/9 56

Hi thanks for the help. It gives the desired result. One small question
though, is it possible to keep adding values in the colums A and B after
performing the Advanced filter copy, and see the new data appear in the
summary columns automatically? I want to give this spreadsheet to a friend to
continue to add data too, and would not want to ask the person to do Advanced
filter copy. thanks