| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cross Tables
I have one CSV file, as attached in the zipped file. The first column is the record number. I want to create a frequency count for each question : Q1, Q2, Q3, Q23. However, there are ";" to separate each number. Besides, how can I made a cross tables let say for example Q2 as the top, cross with all the other questions. The sample output is in worksheet "results1" and "results2". Jai +-------------------------------------------------------------------+ |Filename: SampleCSV.zip | |Download: http://www.excelforum.com/attachment.php?postid=3751 | +-------------------------------------------------------------------+ -- JaiJai ------------------------------------------------------------------------ JaiJai's Profile: http://www.excelforum.com/member.php...o&userid=19484 View this thread: http://www.excelforum.com/showthread...hreadid=399524 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cross Tables
Anyone can help ??? -- JaiJai ------------------------------------------------------------------------ JaiJai's Profile: http://www.excelforum.com/member.php...o&userid=19484 View this thread: http://www.excelforum.com/showthread...hreadid=399524 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Tables - Cross tbl tp Reg tbl | Excel Discussion (Misc queries) | |||
| Cross Referencing | Excel Worksheet Functions | |||
| name cross out | Excel Discussion (Misc queries) | |||
| Cross referencing on tables | Excel Discussion (Misc queries) | |||
| X=y will not cross 0,0 why | Charts and Charting in Excel | |||
![JaiJai[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
