Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in data area on pivot table
I want to generate an event calandar trigger by a database whit text
in the data area. Pivot table is nice to display, sorting, filtering and calculate, but i need to put text field on the data area instead of number. The only other way that i see is to create a formula using match, vlokup, hlookup, with header and row Is there some other way to create a dynamic table with row and column headings, and text values? Thanks, JMB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut doesn't work on data area of pivot table | Excel Discussion (Misc queries) | |||
Data Restructuring: Using Pivot Table w\o the SUM, COUNT etc. Function? | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Pivot table - Text in Data field | Excel Discussion (Misc queries) | |||
Display Text in the Data Area of a Pivot Table | Excel Discussion (Misc queries) |