I am working on creating a list of students who have not turned in an assignment by staff adviser. I want a list that says Beth, here are your students who have not turned in the assignment. I can get a formula to return the students name by owner, HOWEVER, when a line of data doesn't return a result I get blank cells between the last item returned and the next line that returns data.
In this example I simply want Emiliano to fall in the cell directly below Shadai. However, there is a blank cell below Shadai. How do I prevent these blank cells from appearing? I only want to have cells that are filled in.
=IF(AND($AC4=$U$1,$AH4=U$24),CONCATENATE($AD4," ", $AE4),"") I use this formula to return students names by staff adviser. However, when I drag this formula down it will return cells that do not have text/values as blank cells. I want the list to delete all blank cells. How do I do that?
In this example I simply want Emiliano to fall in the cell directly below Shadai. However, there is a blank cell below Shadai. How do I prevent these blank cells from appearing? I only want to have cells that are filled in.
=IF(AND($AC4=$U$1,$AH4=U$24),CONCATENATE($AD4," ", $AE4),"") I use this formula to return students names by staff adviser. However, when I drag this formula down it will return cells that do not have text/values as blank cells. I want the list to delete all blank cells. How do I do that?
