| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tying to extract all data from a pivot pulling from external data
I am trying to pull all values through a pivot referencing an external data
source (another excel sheet). The problem I have it the column has order numbers that are both numberic and alphanumeric. (some are 123456 and others are AB654321). When I get the pivot only the numerical records appear and the alphanumeric records are left blank and I get a subtotal. This goes both ways depending if I format as a number or as text...Any suggestions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract External Data according to a list of references | Excel Discussion (Misc queries) | |||
| HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE | New Users to Excel | |||
| how do i extract data from pivot table to txt file | Excel Discussion (Misc queries) | |||
| External Data and Pivot Tables | Excel Worksheet Functions | |||
| Pivot table using External data | Excel Discussion (Misc queries) | |||
Threaded Mode
