+ Reply to Thread
Results 1 to 2 of 2

GETPIVOTDATA with multiple criteria results in #REF error

  1. 04-06-2017, 02:03 PM #1
    dluhut
    dluhut is offline
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,102

    GETPIVOTDATA with multiple criteria results in #REF error

    Hello,

    Am wondering if Excel gurus here could help me out.

    I have the following ARRAY formula which works.

    Please Login or Register  to view this content.
    However, when I put an additional array on the other Field, it won't work.
    Please Login or Register  to view this content.
    May I know what's the cause of this error?
    Reply With QuoteRegister To Reply
  2. 04-06-2017, 02:49 PM #2
    dluhut
    dluhut is offline
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,102

    Re: GETPIVOTDATA with multiple criteria results in #REF error

    Was able to solve it
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Criteria and Multiple results in Single Cell separated with Comma or Space
    By jagreas in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2017, 02:10 AM
  2. Returning multiple results (closest match not exact) from a table using multiple criteria
    By Hem_79 in forum Excel General
    Replies: 2
    Last Post: 12-16-2016, 07:58 AM
  3. List Top Ten Items - Multiple Criteria Lookup With Multiple Results - Sorted Descending
    By Whizbang in forum Excel General
    Replies: 1
    Last Post: 09-04-2014, 12:14 PM
  4. Multiple Search Criteria produces (list) Multiple results in a single cell
    By snake007uk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2014, 12:13 PM
  5. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  6. PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDULE
    By Porsche944 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-07-2013, 02:22 AM
  7. User Form to Search multiple Criteria to return multiple Results
    By Calieth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-16-2011, 11:57 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1