Results 1 to 6 of 6

Identify the pivot table row label field names

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    98

    Question Identify the pivot table row label field names

    Hi All

    This sounds like it should be simple but simple but I've spent hours googling to find nothing similar
    Is there a formula that can identify a pivot tables row labels?

    See attached png, cell B16

    The reason I ask is two fold. I need the user to be able to see what categories are in the pivot table without using the 'PivotTable Field List'.
    Plus I need to use the list of row labels in other worksheets

    But I don't know if it is possible?

    Any/all advice welcome
    All the best
    Vicky
    (Excel 2010)
    Attached Images Attached Images
    Last edited by vwhite; 04-05-2020 at 02:42 PM. Reason: I hot enter too soon before finishing the post or attaching a png

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Displaying only the max of one field for a specific row label in pivot table?
    By DMC62 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-05-2019, 05:23 PM
  2. Find current pivot table row label field through VBA
    By Chrispelletier in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2016, 02:57 PM
  3. Show query column names behind pivot table field names
    By gbritton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-18-2013, 03:17 PM
  4. How can I sort by non-Parent Row Label field in a Pivot Table?
    By mwatsonca in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-09-2013, 02:40 PM
  5. Changing Pivot Table Field Names Using VBA
    By k_excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2009, 12:46 PM
  6. [SOLVED] How to delete column label from pivot table field
    By Evy Lum in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-27-2006, 09:15 AM
  7. [SOLVED] adjusting pivot table field names to language in use
    By schmidverena@gmx.at in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2006, 10:30 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1