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

Hi - I need to maximize installs while staying within a $3,500,000 budget. In other words, I need to find the highest sum of a combination of cells in column F while the sum of the cells in the same row in column G is less than $3,500,000
Solved by D. E. in 16 mins
I have a submission date and a meeting date, I want it where I can add a certain number of days to determine the meeting date OR I want it where I can add a certain number of weeks to determine the meeting date. However, I do not want to include Weekends into the formula for either days or weeks, ignore fixed date row
Solved by I. H. in 15 mins
I'm stuck. I need a formula that will find the contents of cell A! in sheet1 in column C of sheet 2. If there's match then put in the contents of column A of the same row, into A3 on sheet1. Then to do the same for column B on sheet 1. Etc.
Solved by C. U. in 14 mins
i need to check one cell if it is not null and has a certain format, ov12345 - if not, it should be shipped and go to the next cell in the same column, D(x+1). if ok, I need cell Ax to be populated with that value written between '', simple quotes, and if the next cell of the same column, D(x+1) is not null, then it has to be followed by , (comma). increase the cell row number D(x+1) until I hit a cell with null content. can you help? thank you very much!
Solved by E. H. in 12 mins
Trying to count the number of lower scores in row b vs row d after matching the dates in row a and c.
Solved by Z. S. in 17 mins
I hope you can help. I'm trying to create a formula (in cell C9) of my spreadsheet shown above whereby I can search all countries in the header row (C1:I1) and then add the total number of times that 'Pass' is entered in the cells beneath. The result should equal 6 for the UK. The formula I have used (as shown on the spreadsheet) only seems to count the first columns of cells which has UK in the header.
Solved by O. F. in 25 mins
I am looking to return a list of data based on an amount of times a value is returned in a column. I then am looking to return that in a different tab. So if a person's name is in Column C of Full List tab, then return a list of names that are also in Column A of Full List tab. Display this in List per CM tab in rows 5 and below. The person's name will be listed in row 2 of List per CM Tab.
Solved by G. D. in 22 mins
I'm having a problem with a formula and I am not even sure the functionality exists to make this work. For our purposes I have used a fake spreadsheet just to show the basics of what I need. On 'sheet2' of my workbook I want to return a value from 'C4' on 'sheet1', however, I want the row to change with B3 on 'sheet2'. For instance: =Sheet1!C4 // returns the value I want, but doesn't allow me to easily change the row I want to find when I switch to another sheet. ( I will have at least 100 different formulas that will change with the row number. =Sheet1!C(B3) // doesn't work, but is essentially what I want. So that if I change b3 to 5, the formula will look in =Sheet1!C5
Solved by V. A. in 26 mins
Good day. I am looking for a formula. On excel I have to match number 1 2 or 3 with 13 numbers with commas in 500 rows. Sample is the right line 1,3,1,2,2,3,1,2,3,1,1,2,1 What is the possibility to match it according to the row Ex 1,3,1,2,2,3,1,2,3,1,1,2,1 To show maybe 1,2,2,2,2,3,1,2,3,1,1,2,1 The 2,2 is wrong or Ex 1,3,1,2,2,3,1,2,3,1,1,2,1 To show maybe 1,2,2,2,2,3,1,2,3,1,1,2,1 is right Please help me
Solved by I. Y. in 21 mins
I have a very large list of data on individual members. This data includes each person's Federal District, City, and State. I want to count the number of people who live in each Federal District, City, and State. Attached is a very small version of that list. I have already used Advanced Filtering to create a list of every unique Federal District, City, and State. I am trying to figure out the Excel formula to count all the entries. It is easy to count individual entries from one row (i.e., all cities), but that is not helpful because some city names are duplicated in other states.
Solved by O. B. in 17 mins