pivot table showing text
Check out this link...
http://www.contextures.com/xlfaqPivot.html#Text -- HTH... Jim Thomlinson "ryguy7272" wrote: I've gotten it to work with text. If you double-click the items that you want to put in the Pivot Table (it's called 'Show Field List'), all items will be entered into the 'Row' area. Everything cascades down based on the first item in the 'Show Field List'. Change to suit your needs. Regards, Ryan--- -- RyGuy "Jim Thomlinson" wrote: Pivot tables do not work with Text... -- HTH... Jim Thomlinson "geebee" wrote: hi, i would like to know if there is a way to show a pivot table showing text values instead of sums and counts. i have a a data sheet which only contains text. i was thinking of using a VLOOKUP tat contained multiple AND/OR, but i cant figure that out either. can someone help? thanks in advance, geebee |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com