+ Reply to Thread
Results 1 to 1 of 1

GETPIVOTABLE - similiar column names

  1. #1
    Forum Contributor
    Join Date
    05-27-2012
    Location
    New Brunswick, Canada
    MS-Off Ver
    Excel 2016
    Posts
    327

    GETPIVOTABLE - similiar column names

    G4 has the following formula, which returns a particular cell in a pivot table located at A15:C30. As you can see, B16 and C16 have particular columns names, so that makes it easy. However I have a new pivot table (A1:E13) which now has two columns with the same name. Does anyone know how to locate the proper cell to read from? See attached spreadsheet

    =IFERROR(+GETPIVOTDATA("SL",$A$15:$C$30,"lob_name","Consumer Repair"),"")
    Attached Files Attached Files
    Last edited by Wheelie686; 05-04-2015 at 04:41 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 21
    Last Post: 08-18-2014, 06:44 PM
  2. 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
  3. Excel Names in column to text files names to folder
    By excelaron in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2013, 07:22 PM
  4. Replies: 5
    Last Post: 01-13-2012, 03:20 PM
  5. Looking for something similiar to MIN
    By Steve Haack in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-27-2005, 05:06 AM

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