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 am using Macros to transfer data back and forth from sheet to sheet and am having trouble with formatting. I want to define the color of the row of cells based off a specific column and then add a thick box border around the color block (with multiple rows that will most likely change its exact location).
Solved by M. C. in 12 mins
Hello, I was using Excel and lost my Formulas for the work I have in Sheet2, I also have this problem and I'm not understanding how to have 4 coins equal all 1's in a row and have it put out whether it is true or false.
Solved by F. S. in 28 mins
I'm trying to sum one column if it matches the criteria of a second column on the same row.
Solved by G. E. in 18 mins
I am using phpexcel which does not support some formulas like iferror so I am converting my formulas from iferror to if(iserror(),"","") but I am not able to convert this formula. Can you please check and convert it for me? {=IFERROR(INDEX($Comp.$A$1:$A$45,SMALL(IF(($Comp.B$1:B$45=1),ROW($Comp.$A$1:$A$45)),ROW()-ROW($Comp.A$51)+1)),"")}
Solved by Z. Y. in 27 mins
I want to autofill a formula down a column where one variable fills from the cell to the left on same row and the other variable remains constant to a particular cell
Solved by O. D. in 25 mins
I need help creating a pivot table so it looks like this: Create a table that counts the number of responses to the question, “Which of the below flavors of ice cream do you like?” Show the flavors on the side, and the gender on top of the table. Hint: you may need to drag/move “Σ Values” to a row or column area in order for this to work. Also, can you change the row values to a custom name? Change the name of each flavor so that it only shows the name of the flavor and not “Count of [flavor name]. For example, change “Count of Chocolate” so it only reads “Chocolate” (Hint: in the Custom Name field in “Value Field Settings”, you must use a space before or after the name of the flavor for this to work).
Solved by Z. F. in 24 mins
I'm trying to look up a value in a table in one sheet, and if it matches return the entire row that contains that value into a new table on another sheet.
Solved by G. Q. in 23 mins
what caused the reference error in row starting S157 in the PADS tab?
Solved by Z. F. in 30 mins
I have spreadsheet with 300 rows each of which has 3 columns of data. I want to make a sheet where you can enter in a row #, hit a button, and the other 3 columns of data for that row populate on the page. I think for the button I have to create a macro, but I don't know how to do that to achieve this outcome.
Solved by F. S. in 30 mins
I have an Excel file that has rows and columns full of text, but when I add a filter to the header row, the filter can find any text in the cells?
Solved by V. W. in 25 mins