| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross tab table
I do not want to use Pivot function
I have a table of 5000 row with five column Division District Salesman Factor result If I want to recap the result by Saleman by District by division what is the easy way to turn data to cross tabs . How can i turn these data to Cross tab with the user be able pick a Division-district it will show Factor John Jeff Robin Diane Howard Scott ------------more salesman sales R R G Y G G profit G Y Y Y Y Y GP% Y Y R R R R -- thanks liem |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross Reference Table Data Searching | Excel Worksheet Functions | |||
| contingency table or cross tabulation | Excel Discussion (Misc queries) | |||
| contingency table or cross tabulation | Excel Discussion (Misc queries) | |||
| What formula can I set up to do a cross lookup in an Excel table? | Excel Worksheet Functions | |||
| Cross table | Excel Discussion (Misc queries) | |||
Threaded Mode
