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.
|