Get instant live Excel expert help with ROW Functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
In B13, calculate how much total interest will be paid over the life of the loan. Copy the formula over to D13. And then in cells B15:D15, use a logical function to recommend which company B-Trendz should use to create and maintain the online website. The function should return the company name from row 2 if the website will be maintained for at least two years and the monthly payment is $2,100 or less. If the value is false, the cell should remain blank.
Solved by B. L. in 29 mins
Delete row(s) from a google sheet based on a field matching data in a column in another sheet.
Solved by I. L. in 14 mins
Using the GolfData worksheet, create a PivotTable on a new sheet named PivotAnalysis.
Add the following fields to the PivotTable in the following order: Cust_Type, Home_State, Food_Order.
Move the Home_State field above Cust_Type in the Rows area. Move Cust_Type to the columns area and then remove the Home_State field.
Add the Date field.
Group the dates by Quarter and Year.
Change the format of the data to Currency. Beginning in cell B6, summarize the values in the PivotTable by SUM and then show values as % of Row Total.
Solved by D. A. in 22 mins
I need help using the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references.
Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row.
Solved by E. J. in 24 mins
need help link 2 worksheets. If row added in worksheet1 it should automatically add row to worksheet2
Solved by X. Q. in 12 mins
I'm trying to have a A2:D2 highlight if D2 is blank. And then apply this rule to A3:D3 if D3 is blank and so on without having to individually type this rule for every row I want to apply the rule to.
Solved by M. J. in 22 mins
I need to add on to a formula that will take off 13% off the amount in PROJECTED REPORTS row 12 ONLY
Solved by X. W. in 26 mins
Use the event data on the "Past Events" worksheet (range A3:G103) to construct a PivotTable that will calculate the average attendance for each type of event. Place the PivotTable on a new worksheet. Use the "Type" field as a row label for the analysis. Rename the new worksheet "PT1" (without the quotes). [7 points]
Solved by V. C. in 22 mins
How can I position to a symbolic cell, row or end of data in a row or column
Solved by T. S. in 11 mins
I'm looking to make the Monthly sheet display the total number of items worked by a worker in the month chosen in the Q2 cell of Monthly sheet.
The data is supposed to come from Data Input sheet. Ideally, C1 to L1 will only be populated with the items that were worked ( a similar thing happens in Salarii sheet, row E).
Solved by C. E. in 25 mins