Hi Rolf
Create a Pivot Table.
First create a Dynamic Range
InsertNameDefineName MyRange Refers to
=($A$A1,0,0,COUNTA($A:$A),3)
Place cursor on row 1.
DataPivot TableNextRange =Myrange Finish
Drag Name to Column Area
Drag $ to Data Area
Drag Date to Row Area
Click on Date field and from the PT toolbar select Group and Shoe
DetailGroupMonth
For more help on Pivot Tables
Take a look at the following sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.datapigtechnologies.com/f...es/pivot1.html
http://www.edferrero.com/Tutorials.aspx
--
Regards
Roger Govier
"Rolf" wrote in message
...
in a1,2,3,4 i have Name(brian,brenda,chris)
in b1,2,3,4 i have $ (500, 150,200)
in c1,2,3,4 I have Date (1/15/2006, 2/20/2006, 1/20/2006)
the result i need is: how many money brian in january, februar and so
on.
Hope i get help and thank you in advance.