Use PIVOT table.


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


"Yamorna" wrote:

Can someone please tell me if the following is poosible;

Date Fruit Consumed

01/03/09 Apple
01/03/09 Banana
01/03/09 Pear
02/03/09 Apple
03/03/09 Banana
03/03/09 Pear

I need a function that can tell me how many apples were consumed on
01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The
same for 02/03/09 and 03/03/09.

Hope someone can help.

Yamorna