User Profile
ElsaRobles
Copper Contributor
Joined Jul 04, 2019
User Widgets
Recent Discussions
SCENARIO PIVOT TABLE
Hi everyone, I am really having difficulty understanding what the following steps are sking me to do. The current chart I have is not what I am supposed to be getting. Any help is appreciated please! Thank you!! Switch back to the All Products Use the Scenario Manager as follows to compare the profit per unit in each scenario: Create a Scenario PivotTable report for result cells B17:D17. Remove the Filter field from the PivotTable. Change the number format of the Profit_per_Unit_Sold_Single_Cup, Profit_per_Unit_Sold_Auto_Drip, and Profit_per_Unit_Sold_French_Pre fields (located in the Values box of the PivotTable Field List) to Currency with 2 decimal places and $ as the symbol. Use Single Cup as the row label value in cell B3, Auto Drip as the value in cell C3, and French Press as the value in cell D3. In cell A1, use Profit per Unit Sold as the report title. Format the report title using the Title cell style. Resize column A using AutoFit. Resize columns B-D to 00.12KViews0likes0CommentsVLOOKUP #REF ERROR
Hi, I can't seem to understand why I am getting a ref error for my vlookup formula, I would greatly appreciate any help!! In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s pay rate. Look up the employee ID listed in cell Q2. Use a structured reference to retrieve the value in the 5th column of the Staff Since the formula is looking for a specific staff member’s data, find an exact match.8.6KViews0likes2Comments
Recent Blog Articles
No content to show