Get instant live Excel expert help with ROW Functions

Hi, Sheet 1 is a list of patients with several rows of data per patient. Sheet 2 is a subsection of those patients copied from sheet 1. However, when the patients were copied over using automation, the final row of data from each patient failed to copy over. Do you know how I can fix this without doing it manually? (there are 18,000 ish rows)

I need to alter an array formula. the current formula searches for e=m when q>5. I also need it to search for e=m when q<-5 =IFERROR(INDEX('DR 1994'!$BL$1:$BL$1500,SMALL(IF(('DR 1994'!$E$1:$E$1500="M")*('DR 1994'!$Q$1:$Q$1500>5),ROW('DR 1994'!$Q$1:$Q$1500),FALSE),ROW(A7))),"")

I have a formula not working. =IFERROR(INDEX($AA$6:$BL$305,ROW(Z6)-2,MATCH($Z6,$AA$5:$BL$5,)),"")

I have a spreadsheet with over 7,000 rows and need to insert a row in between them all. How can I do this?

I need to print row 2 on each page and not sure how to set it up

In cell J10, enter an INDEX function that will convert the Call Day to the actual weekday found in row 1 of the DayofWeek named range. Resize the column width excel vba as needed.

how do i calculate the NPV across two columns A and B and 36 rows, where column A has a spend across every row and Column B has a spend only for 3 random rows

I need a formula to see if there are any values that are the same in a row of 20 cells

I am trying to create an "Average" field to calculate the average of multiple columns in a pivot table (each column separately that is) knowing that the rows under each column will change according to slicer selection. I was able to create the formula to calculate that but i just noticed that once the reference word in my formula (which is "grand total") falls after row 99 then the formula gives no results !! here is the formula =IFERROR(AVERAGEIF(INDIRECT(B10&"15:"&B10&RIGHT(CELL("address",INDEX($A$13:$W$101,MATCH("Grand Total",$A$13:$A$101,0),1)),2)-1),"<>0"),"") any suggestion?

In cell E12, add an IF statement using a nested OR function that will return any notes associated with the issue. If there are more than 10 issues reported with a grade below a C in cell D12, or when the number of scores less than C divided by the total calls in cell C12 is greater than 50%, then "Explore Issues" should display. Otherwise, the result will be blank. Copy the formulas in B12:E12 down through row B16:E16.