LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple problem, simple formula, no FUNCTION ! Ron@Buy Excel Worksheet Functions 6 September 28th 07 04:51 PM
Simple Code, I think... [email protected] Excel Worksheet Functions 1 August 2nd 06 08:09 PM
Function for simple code goeppngr Excel Programming 1 February 28th 06 04:14 PM
need a simple code Peter McCaul Excel Programming 1 August 11th 04 08:13 PM
Simple For Each Next code Keith Willshaw Excel Programming 0 July 28th 03 12:57 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"