AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() This information is used to determine which PivotTable contains the data that you want to retrieve.ġ to 126 pairs of field names and item names that describe the data that you want to retrieve. This needs to be in quotes.Ī reference to any cell, range of cells, or named range of cells in a PivotTable. ![]() The name of the PivotTable field that contains the data that you want to retrieve. The GETPIVOTDATA function syntax has the following arguments: In this example, =GETPIVOTDATA("Sales",A3) returns the total sales amount from a PivotTable: The GETPIVOTDATA function returns visible data from a PivotTable. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More.
0 Comments
Read More
Leave a Reply. |