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 want to return a date value in a row from a value in the row below. This is the formula I tried =IF(D5:DC5,"1",D3:DC3) but I get a value# error. So if cell E5 contained a 1, then I want excel to tell me what is in the cell at the top of the column it appears in.... did that come across ok?
Solved by S. F. in 21 mins
I'm working on a schedule and want a drop down list of the names that work a specific day. I have the names of the people in row 3 columns G:V I have the schedule in row 5 to 11 (1st week) I want to have a drop down for each row in column X, but it should only display the names that actually have a shift that day. For example in row 5 only 3 people have shifts(G5:I5), so the drop down in X3 should only contain the names from G3:G5.
Solved by B. U. in 15 mins
Hello, Team I need your help, I want to copy the name row from multiple files in one sheet
Solved by K. F. in 14 mins
Inserting a new row in the base table that feeds a pivot table is causing existing calculations in the pivot table to break.
Solved by K. B. in 19 mins
Hello my problem with excell is I have one row that has clients full name, email, and phone number and its all sepparated by enter, not comma, or tab, or semicolon, how do I split it in to 3 columns these three pieces of info in the checking off other box
Solved by I. J. in 21 mins
Im trying to create a macro that fills in the names of months, January to December, across a row beginning from a selected cell. I am told to use the macro recorder with relative referencing to create the macro. Then i am supposed to create a button for the macro and display it on the Quick Access Toolbar(QAT). Lastly I'm supposed to run my macro from the toolbar
Solved by E. F. in 28 mins
I have a 10,000+ row data set that is of customers that have purchased video, data and phone services. I'm trying to find out which customers purchased more than one of these. Also, in the same dataset, i'm trying to find out how many customers purchased the following product combinations: 1. Data+Phone 2. Phone+Video 3. Video + Data 4. Video Only
Solved by V. E. in 15 mins
My excel sheets keep getting into strange entry boxes where instead of clicking on a box and outlining one box, clicking on a box gives an outline that off or created than the box - generally in the same row bout variably covering more than one column. Enter data and the data will go into more than one place (box to right or left. I think Microsoft has really ruined the product from the earlier version so is this just MS getting back at me. I have the GD Office 365 that stinks as a whole.
Solved by K. D. in 14 mins
Hello, I am trying to find a formula that will send the last numerical value in a row (the row has one cell aplha and the next one numeric, the last entry will always be a date, I need this date to be sent to another sheet within the workbook)
Solved by T. D. in 16 mins
I am trying to fill a formula left across columns and each column formula change the row number instead of change the column letter. For example. The original formula is as follows: =(Data!C2/Data!B2). I want it to proceed as I fill across columns as =(Data!C3/Data!B3) then =(Data!C4/Data!B4) and so on. Instead it fills like this:=(Data!D2/Data!C2) and then =(Data!E2/Data!D2)
Solved by A. C. in 23 mins