A pivot tabel will work for that... Select Data | Pivot table or Pivot
Chart... | Follow the wizard. Put the rate in the left column and the months
in the top row. Add the GBP to the data area and you are done... no formulas
needed...
--
HTH...

Jim Thomlinson


"eva cheng" wrote:

I am using excel 2003

I have a file like below
Rate month GBP
1.46 FEB 2000
1.47 MAR 3000
1.47 APR 3500
1.48 MAY 1000

I want to create summary
Rate FEB MAR APR MAY
1.46 2000
1.47 3000 3500
1.48 1000

I can use sumif function to return the total, however, how can I insert only
the unique rate in the first column automatically.

Thanks a lot !
eva cheng