CREATE.TABLE

[Guest]

In Excel 2002-2003 it was possible to use the FUNCTION CREATE.TABLE(A1;B1) to
make a pivot table based on the 2 inputvalues ex. A1 and B1.
The result on A1 and B1 was displayed in the pivot table based on the tabels
row and column headers.

Now this function sems gone in Excel2007 and I can't find any new way to
make the pivot table on the same facts

Allt the help functions talk about is how to make a pivottable based on
tables, not on just 2 inputvalues and the result of that !!

Please help me ... getting pretty desperat here !!!

 

[Roger Govier]

Hi Patrik

That was not the method of creating a Pivot Table in any version of
Excel.

What you are looking for is the facility from XL2003 found under
Data>Table
This can be found in XL2007 on the Data Tab>What If Analysis> 3rd item
Data Table

 

[Guest]

Hey ... many thanks Roger ... this solved everything.

--
regards
Patrik S -swe-


"Roger Govier" skrev:

Hi Patrik

That was not the method of creating a Pivot Table in any version of
Excel.

What you are looking for is the facility from XL2003 found under
Data>Table
This can be found in XL2007 on the Data Tab>What If Analysis> 3rd item
Data Table