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 have a text file with lots of data separated by a comma, the issue is when I import it adds the data as a row rather than a column, so I basically need the data to be transposed before being added. Help!
Solved by Z. D. in 12 mins
I have a spreadsheet with IF Statements in multiple cells of a single row entry. I need to be able to allow users to insert a new row that will keep the IF Statements intact. I have created a macro New Row button but don't know how to set it up to insert the new row with the IF Statements...or is there is a different way to do it without the macro button.
Solved by T. W. in 23 mins
I have a spreadsheet with IF Statements in multiple cells of a single row entry. I need to be able to allow... I'm not seeing a download button to grab the spreadsheet....
Solved by O. H. in 22 mins
I had a formula in B1, C1.... which is not working. I want results as ----for example every time I add a number in next row the formula will do a calculation B3-B4, if I add a number in B5 the calculation should be B5-B3. It always should use a new number - B3. The formula in B1 didn't calculate for some reason and if the result is "-" it shows as "0". Can anyone help? Please ....Please
Solved by Z. Y. in 15 mins
I am trying to get a spreadsheet to subtract a row of numbers by a set value.
Solved by G. W. in 12 mins
Hi, I have a google sheet shared by the team, I set the conditional formatting, the row will turn into certain colors as cell values are updated, the next thing I want to accomplish is to move all the rows that has changed to certain colors to another spreadsheet, automatically...Is it something achievable?
Solved by X. J. in 22 mins
I have a data with 4 columns I want to put two conditions on two different columns( Column1 and column2) and if this both conditions met then need their corresponding columns(column 3& column 4) values. using excel functions only (not using sort&filter tab) is there any way to do? enter image description here IF in column1( BAC US ) and in column2(B) it should give 444 in c3 and 9.825 in c4 same for 4th row
Solved by G. U. in 22 mins
SPREADSHEET SOFTWARE USED: Microsoft Excel 97-2004 (.xls) MY QUESTION IS ABOUT: IF STATEMENT DESCRIPTION: I have a data with 4 columns I want to put two conditions on two different columns( Column1 and column2) and if this both conditions met then need their corresponding columns(column 3& column 4) values. using excel functions only (not using sort&filter tab) is there any way to do? enter image description here IF in column1( BAC US ) and in column2(B) it should give 444 in c3 and 9.825 in c4 same for 4th row
Solved by V. S. in 21 mins
I need to develop a pop up menu that will present me selection options, and then based on my selections, scan through my spreadsheet and highlight the correct row. When I'm done with the row remove the highlighting and allow me to start the selection process over again, or allow me to input data into the spreadsheet.
Solved by I. B. in 22 mins
I have a 2 worksheet workbook. Sheet1 is the start. i want the data in columns "A" and "B" to copy and paste into columns "B" and "C" in the first available row on Sheet2 if "Yes" is entered into Column "F" in Sheet1. The macro should search all of Sheet1 and repeat the process until all occurrences of "Yes" are moved to Sheet2. The macro should also delete the entire row on Sheet1 is "No" is entered into column "F". Lastly, once the "Yes" data is copied to Sheet2 the row on Sheet1 should be deleted.
Solved by I. H. in 15 mins