View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
A[_4_] A[_4_] is offline
external usenet poster
 
Posts: 5
Default Is there a simple function code to do it?.


Jim Thomlinson ha scritto:

Why not use a pivot table. Pace you rcursor in the middle of the data and
select Data - Pivot Table - follow the wizard (or just choose finish as XL
will normally make all of the correct assumptions).

Place the X's in the left column and the Y's across the top and the values
in the middle...
--
HTH...

Jim Thomlinson


Thanks for fast reply.
Yes, this works. But I must insert the values in a particular excel
file, making some procedures before putting the values in it so, I
can't go for a basic Pivot Table. Another idea? Thanks.

Ale.