getpivotdata - Search Results

Pivot table: matching item name from another sheet and showing unit price with pivot table

Started by Hasnat124‎, 06-07-2023 12:24 AM

getpivotdata, index and match function, pivot table 2016

5

327

Last Post By:: Last Post: 06-07-2023 05:50 AM; by sandy666

Forum:
Excel Charting & Pivots

[SOLVED] GetPivottable function not working with grouped range of cells

Started by Joe5421‎, 03-30-2023 07:46 AM

5

341

Last Post By:: Last Post: 04-05-2023 05:53 PM; by Limor_OP

Forum:
Excel Formulas & Functions

Structured Table References in GETPIVOTDATA

Started by Nerdio‎, 08-19-2021 03:47 AM

0

330

Last Post By:: Last Post: 08-19-2021 03:47 AM; by Nerdio

Forum:
Excel General

GETPIVOTDATA() with a pivot table from a data model

Started by Nerdio‎, 08-18-2021 07:05 AM

2

1,686

Last Post By:: Last Post: 08-19-2021 09:07 AM; by Nerdio

Forum:
Excel Charting & Pivots

#REF with Date with GETPIVOTDATA

Started by spasse‎, 09-24-2020 09:44 AM

1

403

Last Post By:: Last Post: 09-25-2020 05:06 AM; by XLent

Forum:
Excel Formulas & Functions

VBA =GetPivotData() producing runtime error 1004

Started by vwhite‎, 09-10-2020 07:23 PM

2

874

Last Post By:: Last Post: 09-11-2020 04:35 AM; by vwhite

Forum:
Excel Programming / VBA / Macros

[SOLVED] =GETPIVOTDATA returning #REF! when using '=' to pull value through to another cell?

Started by vwhite‎, 09-03-2020 10:06 AM

2

314

Last Post By:: Last Post: 09-03-2020 11:35 AM; by vwhite

Forum:
Excel Formulas & Functions

GetPivotData Using Reference in another Sheet

Started by mikey141‎, 07-29-2020 05:11 AM

getpivotdata, indirect, lookup, match & index

0

779

Last Post By:: Last Post: 07-29-2020 05:11 AM; by mikey141

Forum:
Excel Charting & Pivots

Sumif Formula Based on Pivottable

Started by NV1‎, 04-06-2020 06:31 AM

1

327

Last Post By:: Last Post: 04-06-2020 06:55 AM; by Richard Buttrey

Forum:
Excel Formulas & Functions

How to work two pivots together!

Started by makaii‎, 12-06-2019 12:16 PM

cross reference, formulas, getpivotdata, pivot

1

399

Last Post By:: Last Post: 12-08-2019 11:45 AM; by Ace_XL

Forum:
Excel Formulas & Functions

[SOLVED] SUM the split of working hours to another spreadsheet??

Started by BigErnKingpin‎, 08-26-2019 03:02 AM

formula help, getpivotdata, pivot, sum, sumif

8

424

Last Post By:: Last Post: 08-26-2019 04:31 AM; by BigErnKingpin

Forum:
Excel Formulas & Functions

[SOLVED] Dynamic criteria for SUMIF or dynamic getpivotdata

Started by Mikes_KM‎, 07-20-2019 06:50 PM

dynamic, excel, getpivotdata, sumif, trading

8

1,872

Last Post By:: Last Post: 07-21-2019 12:53 PM; by Mikes_KM

Forum:
Excel Formulas & Functions

GETPIVOTDATA Issues

Started by Pivot on this‎, 08-10-2018 07:28 PM

3

873

Last Post By:: Last Post: 08-11-2018 05:32 PM; by jason.b75

Forum:
Excel Formulas & Functions

GETPIVOTDATA formula linked to Combo Box

Started by esbencito‎, 04-12-2018 11:17 PM

2

543

Last Post By:: Last Post: 04-12-2018 11:33 PM; by esbencito

Forum:
Excel General

GETPIVOTDATA vs. INDEX/MATCH

Started by esbencito‎, 03-09-2018 02:40 AM

22

7,664

Last Post By:: Last Post: 03-14-2018 02:26 AM; by esbencito

Forum:
Excel General

[SOLVED] GetPivotData drag for entire column

Started by Aagaard806‎, 11-03-2017 10:26 AM

1

3,713

Last Post By:: Last Post: 11-03-2017 12:02 PM; by xlnitwit

Forum:
Excel Charting & Pivots

HELP WIth Using GETPIVOTDATA and IF In VBA

Started by JMB22SP‎, 07-18-2017 01:12 PM

0

1,037

Last Post By:: Last Post: 07-18-2017 01:12 PM; by JMB22SP

Forum:
Excel Programming / VBA / Macros

Getpivotdata Error

Started by lisa21‎, 07-12-2017 09:24 AM

7

787

Last Post By:: Last Post: 07-12-2017 10:07 AM; by CK76

Forum:
Excel General

[SOLVED] Error on complicated Vlookup/GetPivotData Formula

Started by manny88‎, 11-09-2016 05:49 PM

3

799

Last Post By:: Last Post: 11-10-2016 09:37 AM; by dosydos

Forum:
Excel Formulas & Functions

[SOLVED] GETPIVOTDATA - Can you reference subtotals?

Started by Cortney306‎, 09-12-2016 07:41 PM

6

4,220

Last Post By:: Last Post: 09-13-2016 12:11 PM; by Cortney306

Forum:
Excel Charting & Pivots

Getpivotdata formula with two variables (month and country)

Started by Hypnopoison‎, 07-27-2016 10:06 AM

8

3,789

Last Post By:: Last Post: 07-28-2016 08:50 PM; by bigroo1958

Forum:
Excel General

Retrieve data from Pivot under Filter

Started by zeta274‎, 03-09-2016 07:13 AM

excel, filter, formula, getpivotdata, pivot

1

671

Last Post By:: Last Post: 03-09-2016 03:39 PM; by ChemistB

Forum:
Excel Formulas & Functions

GETPIVOTDATA for a range

Started by JasonLeisemann‎, 12-22-2015 11:34 AM

criteria ranges, excel 2010, getpivotdata, pivot tables

2

2,868

Last Post By:: Last Post: 12-23-2015 11:12 AM; by JasonLeisemann

Forum:
Excel Charting & Pivots

extracting data from a pivot table.

Started by lougs7‎, 11-16-2015 02:25 PM

=getpivotdata, copy & paste, getpivotdata, pivot, pivottable

2

937

Last Post By:: Last Post: 11-16-2015 04:54 PM; by newdoverman

Forum:
Excel General

issues with basic =GETPIVOTDATA grandtotals and paste in desired columns. Don't know how!

Started by lougs7‎, 11-16-2015 12:44 PM

=getpivotdata, copy & paste, getpivotdata, pivot table, pivot table calculation

2

778

Last Post By:: Last Post: 11-16-2015 01:54 PM; by lougs7

Forum:
Excel General

My getpivotdata (powerpivot) uses scientific numbers in the reference!?

Started by mr_jules‎, 06-10-2015 03:00 AM

getpivotdata, powerpivot, scientific notation

5

3,308

Last Post By:: Last Post: 08-01-2021 12:58 PM; by pgiolo

Forum:
Excel Formulas & Functions

GETPIVOTDATA Dates Reference Returning #REF! Error

Started by Jake32008‎, 03-09-2015 12:50 PM

5

2,289

Last Post By:: Last Post: 03-09-2015 03:42 PM; by Jake32008

Forum:
Excel Formulas & Functions

[SOLVED] GETPIVOTDATA – How to force getpivotdata to accept missing data

Started by scottc_00‎, 01-14-2015 11:34 AM

39

10,162

Last Post By:: Last Post: 02-11-2015 03:23 PM; by scottc_00

Forum:
Excel Formulas & Functions

[SOLVED] (DELTE THIS THREAD PLOX) Getpivotdate ref error

Started by dramadeur‎, 10-12-2014 09:14 PM

1

744

Last Post By:: Last Post: 10-12-2014 10:10 PM; by FDibbins

Forum:
Excel Charting & Pivots

Sum of values in date range returned via GETPIVOTDATA causes #REF errors

Started by 01111000‎, 06-05-2014 06:25 PM

14

4,913

Last Post By:: Last Post: 06-11-2014 03:32 PM; by 01111000

Forum:
Excel General

GETPIVOTDATA all or none items in a field

Started by tompope84‎, 10-23-2013 12:38 PM

0

2,721

Last Post By:: Last Post: 10-23-2013 12:38 PM; by tompope84

Forum:
Excel Formulas & Functions

Adding a series of cells in a Pivot Table using GetPivotData function

Started by Pratik Bhatia‎, 10-15-2013 10:00 AM

0

869

Last Post By:: Last Post: 10-15-2013 10:00 AM; by Pratik Bhatia

Forum:
Excel Charting & Pivots

[SOLVED] Problem: GETPIVOTDATA Between Workbooks

Started by RagerPie‎, 08-21-2013 04:12 PM

=getpivotdata, getpivotdata, link workbooks

6

14,614

Last Post By:: Last Post: 08-21-2013 07:29 PM; by RagerPie

Forum:
Excel Charting & Pivots

sending blanks back from pivot table with GETPIVOTDATA formula

Started by HeikEve‎, 05-23-2013 09:55 PM

0

749

Last Post By:: Last Post: 05-23-2013 09:55 PM; by HeikEve

Forum:
Excel Charting & Pivots

Pivot Table ShowDetail (Double Click) shows too many entries

Started by oljasmn‎, 05-17-2013 08:33 PM

doubleclick, excel, getpivotdata, pivot table, showdetail

8

7,441

Last Post By:: Last Post: 05-18-2013 11:41 AM; by VKS

Forum:
Excel Programming / VBA / Macros

Search:

Search: Replies Views Search took 0.01 seconds.

Pivot table: matching item name from another sheet and showing unit price with pivot table

[SOLVED] GetPivottable function not working with grouped range of cells

Structured Table References in GETPIVOTDATA

GETPIVOTDATA() with a pivot table from a data model

#REF with Date with GETPIVOTDATA

VBA =GetPivotData() producing runtime error 1004

[SOLVED] =GETPIVOTDATA returning #REF! when using '=' to pull value through to another cell?

GetPivotData Using Reference in another Sheet

Sumif Formula Based on Pivottable

How to work two pivots together!

[SOLVED] SUM the split of working hours to another spreadsheet??

[SOLVED] Dynamic criteria for SUMIF or dynamic getpivotdata

GETPIVOTDATA Issues

GETPIVOTDATA formula linked to Combo Box

GETPIVOTDATA vs. INDEX/MATCH

[SOLVED] GetPivotData drag for entire column

HELP WIth Using GETPIVOTDATA and IF In VBA

Getpivotdata Error

[SOLVED] Error on complicated Vlookup/GetPivotData Formula

[SOLVED] GETPIVOTDATA - Can you reference subtotals?

Getpivotdata formula with two variables (month and country)

Retrieve data from Pivot under Filter

GETPIVOTDATA for a range

extracting data from a pivot table.

issues with basic =GETPIVOTDATA grandtotals and paste in desired columns. Don't know how!

My getpivotdata (powerpivot) uses scientific numbers in the reference!?

GETPIVOTDATA Dates Reference Returning #REF! Error

[SOLVED] GETPIVOTDATA – How to force getpivotdata to accept missing data

[SOLVED] (DELTE THIS THREAD PLOX) Getpivotdate ref error

Sum of values in date range returned via GETPIVOTDATA causes #REF errors

GETPIVOTDATA all or none items in a field

Adding a series of cells in a Pivot Table using GetPivotData function

[SOLVED] Problem: GETPIVOTDATA Between Workbooks

sending blanks back from pivot table with GETPIVOTDATA formula

Pivot Table ShowDetail (Double Click) shows too many entries