Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to analyze data?
The output will look like ...
ColumnA mod1 mod2 mod3 (blank) Grand Total cust1 2 1 3 cust2 1 2 3 (blank) Grand Total 2 2 2 6 "linda" wrote: hi! i've got a table in excel worksheet which part of it looks like this: columnA|column B| cust1 | mod1 cust2 | mod2 cust1 | mod1 cust1 | mod2 cust2 | mod3 cust2 | mod3 but,i need to recreate the table in a new worksheet to be analyze,to create chart from the data..this is what i expect: cust | mod1 | mod2 | mod3 | cust1| 2 | 1 | cust2| 0 | 1 | 2 i've try to use filter,but still can't do this..i dont want to create it using pivot table cause i want it to be static..i hope to do this in macro cause i want to assign it to a button but i'm not really familiar with macro..so,i dont have any idea to solve my this.is there any solution for this?if yes,how? thanks in advanced. -- Regards, Linda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to analyze data?
Hi Irfan..
thanks for reply..i already try that before but thats not what i want because i dont want user to choose which value they want to view.my suggestion right now is to do it manually in macro but i dont have any idea in the coding. your help is very appreciated=) -- Regards, Linda "Irfan Khan" wrote: The output will look like ... ColumnA mod1 mod2 mod3 (blank) Grand Total cust1 2 1 3 cust2 1 2 3 (blank) Grand Total 2 2 2 6 "linda" wrote: hi! i've got a table in excel worksheet which part of it looks like this: columnA|column B| cust1 | mod1 cust2 | mod2 cust1 | mod1 cust1 | mod2 cust2 | mod3 cust2 | mod3 but,i need to recreate the table in a new worksheet to be analyze,to create chart from the data..this is what i expect: cust | mod1 | mod2 | mod3 | cust1| 2 | 1 | cust2| 0 | 1 | 2 i've try to use filter,but still can't do this..i dont want to create it using pivot table cause i want it to be static..i hope to do this in macro cause i want to assign it to a button but i'm not really familiar with macro..so,i dont have any idea to solve my this.is there any solution for this?if yes,how? thanks in advanced. -- Regards, Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
who to analyze data with more than 30,000 rows in excel | Excel Discussion (Misc queries) | |||
Analyze Data | Excel Worksheet Functions | |||
How do I statistically analyze data across multipe worksheets? | New Users to Excel | |||
Analyze & Filter data in a notepad file | Excel Discussion (Misc queries) | |||
How do I analyze data from a survey in excel | Excel Worksheet Functions |