Formula / Pivot Table Function Help

[Paul]

I am tryin to create a formula which will give me the
values in column C

A B C
1 15/01/2004 23/06/2004
2 05/07/2004 05/07/2004
3 31/08/2004 31/08/2004
1 23/06/2004 23/06/2004
2 15/04/2004 05/07/2004
3 15/01/2004 31/08/2004

A= Item
B= Order Date
C= To show the latest date that it was ordered against all
entries for each item.
What I am trying to achieve is to show orders from a
particular day in a pivot table but also but be able to
see the full history of that item also.
If this is possible to do in a pivot table without this
formula then a few pointers in the right direction would
be greatly appreciated.

Paul

 

[Frank Kabel]

Hi
enter the following array formula in C1 (entered with
cTRL+SHIFT+eNTER):
=MAX(IF($A$1:$A$100=A1,$B$1:$B$100))
and copy down