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 trying to work on a google form and the spreadsheet that records the responses. I know that when it records the responses it adds a row to the spreadsheet therefore my formulas don't update. I tried adding a sheet to the workbook called Total Due and using the query function to pull the data from the responses but it doesn't seem to be capturing everything and need help in getting all the data to pull from the responses over to the Total Due worksheet.
Solved by S. H. in 11 mins
I have a row of numbers and have graphed them in a line graph. I have added a trend line and I can see the trend is going down. What I would like to add is.... if the trend continues, we will hit (say) zero (lowest point) in x time frame. I have four years worth of history in monthly instalments. So 48 numbers. Best example is say profits... Each month the numbers go up and down and the trend line is showing the curve. So, how do I add the other data on to show how many months till zero?
Solved by C. H. in 30 mins
I have numbered by list of inquiries as E00001, E00002, E00003 and so on.. (row wise) However, each inquiry may have more items and hence i number them as E00002a, E00002b and so on. (consecutive rows) I my next sheet i would like to link the inquiry nos. (i.e if i enter E00002 all the rows which have E00002 including E00002a, E00002b should be listed consecutively as in the inquiry sheet. I tried with =INDEX(Marketing!$A$6:$A$22,MATCH('Mktg-Comm'!A19,Marketing!$A$6:$A$22,0)+1) In the above formula all the Enquiry nos. next to E00002 is being listed. Need a formula to break the loop once E00002 and the consecutive items pertaining to E00002 is over.
Solved by V. Y. in 23 mins
In my excel spreadsheet I need to put in a formula so it adds column C5 to G5 then working down the spreadsheet to C149 to G149, so totals going across the page not down but adding each row individually as I go
Solved by B. B. in 18 mins
I'm trying to get cells in a row to populate based on a selection in a drop down list I have created.
Solved by T. H. in 15 mins
I'm trying to develop a formula which will concat from 2-15 text cells in a row, with a colon (:) between text values in the combined cell.
Solved by X. Q. in 13 mins
I have a large spread sheet I need to filter. I can't filter because there are to many blank rows and random blank cells. Ideally I want a formula to delete every row that doesn't have something in a particular column. If not I need a formula to delete just the blank rows but not all the blank cells. Every time i delete the blank cells it deletes everything and i can't filter to select the blank rows because there are two many empty rows and headings.
Solved by I. F. in 27 mins
I have an excel workbook with multiple sheets. I would like a macro which would move the cursor from sheet1 to sheet 2 based on the following description. I have cell "B4" on sheet 1 which we will enter a specific code into. Based on that code or number I would like the macro to find the code in cell "B4" on sheet2 in a table. Once the code(row) is found, have the cursor move 12 columns over to column"O" and make that cell the active cell. The place a time stamp in the active cell.
Solved by Z. H. in 26 mins
I attached a calendar to the cells in the Excel and when I click on the top row in the column, I receive error, and one of the option is Debug. when I click on the Debug it refers me to the following line in VBS
Solved by G. H. in 18 mins
Need a way to automatically consolidate a list to one row per entry
Solved by F. F. in 28 mins