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
I need to calculate the daily rate and once the date has passed the current day it needs to drop down to row 42 in PROJECTED REPORTS. The correct logic lies in row 15, there is an example there for you
Solved by X. L. in 27 mins
I need to create a check box that'll make data in a given row applicable to tax or not. I have a table and can show you what I mean.
Solved by O. B. in 25 mins
I need row 2 to always show when I scroll down and to print on each pageprint on each page and
Solved by F. J. in 18 mins
I need a formula that will give me the days between 2 dates for data in a pivot table I have, however if a row only contains a date in one of the two columns I need it to display nothing in the output column, right now it displays a long negative number.
Solved by E. B. in 27 mins
In cell B3, create a formula to retrieve the item within each category in cell B1. Enter an INDIRECT function to return the item numbers by category. The function will reference cell $B$1 (absolute) and index the value of the intersection of row 3 (A3) and column 1.
Nest the function in an IFERROR function to return a blank cell if no items exist within the category.
Solved by S. H. in 18 mins
Please look at row 142 and column K142 the formula is not working
Solved by Z. H. in 20 mins
I have a formula that is supposed to take in, Certain criteria on the calculator sheet from the eco3_deemed_scores_2018 sheet (which is the data sheet) The following criteria that is supposed to be taken in on the calculator sheet is - Measure catagory, measure type, property type, pre main heating source, post main heating source and name of uplift it is then supposed to display the relevant matching cost score from that row, but every time I try it just says no match, please help
Solved by C. E. in 18 mins
I need a formula, macro or something else that counts cells in a row that are not colored (with a white background) and I need this operation applied to an entire destination column. The cells (white or colored) all have varying numerical values but its the non-colored cells that are of interest because they indicate correctly answered questions for a student on an exam.
Solved by K. L. in 26 mins
Can you extend the color row for me, in Jan April July and oct
Solved by S. D. in 19 mins
I have a spread sheet for payroll and I need to add another category that will change the color of the row
Solved by D. S. in 15 mins