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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I inserted a row in the middle of an excel spreadsheet where I want to type text that will not fit into the column width. What do I need to do to allow the text I want to enter?
Solved by T. Y. in 11 mins
Select cell F4 and make it an absolute reference to the row but not the column. c. Type )* for the closing parenthesis and multiplication.
Solved by X. H. in 24 mins
I would like to autofill filtered columns with a series list of numbers and then unselect the filter and have the series list of numbers not change. For example if I associate a 1 with that row it remains 1 no matter the order of filtered rows. I am not sure if this is possible without an add-in or vba.
Solved by A. E. in 14 mins
I need to do a mailmerge to everyone on the attached excel spreadsheet that has an "x" marked in row K- How do I do that?
Solved by G. Q. in 22 mins
I need a column to show me which fruits have the most occurences in a row.
Solved by B. J. in 14 mins
I need to sum the total hours for all the hours in the row.
Solved by D. J. in 29 mins
I am trying to say if the Priority level is H and if the item is still OPEN then turn the row red and flag.
Solved by K. Y. in 16 mins
I want to set a formula to my document but can't figure out where to start. Basically if A4 to J4 are filled with text or numeric value than the row will be the color green. If cells A4 to J4 are not all filled with text or numeric value than the row will be the color red.
Solved by C. D. in 20 mins
This Feature Billing spreadsheet is something we use at our company for quoting our clients. We build custom software, and clients typically have very similar feature requests. The New Quote Tab is where a sales person would work. As they talk to the client, the put an "x" in the Selection column (Column H). This generates a price. With that said, each of those selections maps to another set of requirements that we want to communicate with our developers. The "Base-Components-With-Subtasks" tab represents the start of listing out the subtasks. If the sales person puts in X in row 2 of the New Quote tab, our developers need to know to build rows 2-5 of on the "Base-Components-With-Subtasks" tab. The output of this is supposed to be on the "Populated Story Map Tab." Currently I have it so it lists out all the items (and only those items) that are being selected from the New Quote tab, which is a great first step. But I also need it to list out all of the sub-tasks (in individual rows) that the selection maps to on the Base-Components-With-Subtasks. For example, on the Populated Story Map tab, there should be 4 rows for story 1.
Solved by V. H. in 27 mins
I am trying to match different rows together and receive a count of how many match the criteria with row I. Basically for row Y i want to count how many instances are both nfp for rows I and K. Another problem is how would I do it so it would give me a count for how many are nfp in row I and fp in row K. I am doing this multiple times for each value of c.
Solved by V. A. in 23 mins