Question about Microsoft Excel for PC
When I have a pivot table it has certain numbers I want to grab. If I link to a cell within the pivot table it uses text to search for the data in the pivot table. A2 =GETPIVOTDATA("P/S",Sales!$A$3,"Sales Categories","Range < 50")
Rather than use "Range < 50" I want to grab text from another cell (say B2= "Range < 40") to make the model more dynamic. However the get formula searches by text and not the cell link. What I want is something like this A2 =GETPIVOTDATA("P/S",Sales!$A$3,"Sales Categories",&B2) but unfortunately this does not work.
Do you know how to get around this issue?
Formula for the keys or short curt for excel
Posted on Jul 28, 2008
This problem arose from Excel Verson 2003 onwards - It does not appear in a sum function where the range is greater than one cell.
The easiest solution is to manually linking the cell in your formula and typing in the cell reference rather than looking it up
Posted on May 25, 2009
Posted on Jul 22, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Oct 31, 2008 | Computers & Internet
on Nov 11, 2013 | Microsoft Excel Computers & Internet
May 01, 2009 | Computers & Internet
Jan 10, 2009 | Microsoft Office Standard for PC
Feb 03, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
155 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: