My query returns “Query completed with an empty output.” and shows N/A in the cell value.

I am trying to find a way for google sheets to change the result of a division equation based on two different conditions. If it is dividing a 0 by a 0, I want it to be blank (so I use IFERROR and then leave it blank, that part is working).

I am tracking information about students. Sheet 1 has each student in their own row, and the columns are different characteristics of that student (for example, their t-shirt size and their grade), as well as their attendance at each session of a class. On Sheet 2, I want to create a stand-alone list of all the students from Sheet 1 who were absent for a given class session. I also want the list on Sheet 2 to update any time there’s a change in the column on Sheet 1. For example, if a student was marked here, but was actually absent.

I am tracking information about students. Sheet 1 has each student in their own row, and the columns are different characteristics of that student (for example, their t-shirt size and their grade), as well as their attendance at each session of a class. On Sheet 2, I want to create a stand-alone list of all the students from Sheet 1 who were absent for a given class session. I also want the list on Sheet 2 to update any time there’s a change in the column on Sheet 1. For example, if a student was marked here, but was actually absent.

I am tracking information about students. Sheet 1 has each student in their own row, and the columns are different characteristics of that student (for example, their t-shirt size and their grade), as well as their attendance at each session of a class. On Sheet 2, I want to create a stand-alone list of all the students from Sheet 1 who were absent for a given class session. I also want the list on Sheet 2 to update any time there’s a change in the column on Sheet 1. For example, if a student was marked here, but was actually absent.

I am tracking information about students. Sheet 1 has each student in their own row, and the columns are different characteristics of that student (for example, their t-shirt size and their grade), as well as their attendance at each session of a class. On Sheet 2, I want to create a stand-alone list of all the students from Sheet 1 who were absent for a given class session. I also want the list on Sheet 2 to update any time there’s a change in the column on Sheet 1. For example, if a student was marked here, but was actually absent.

I am tracking information about students. Sheet 1 has each student in their own row, and the columns are different characteristics of that student (for example, their t-shirt size and their grade), as well as their attendance at each session of a class. On Sheet 2, I want to create a stand-alone list of all the students from Sheet 1 who were absent for a given class session. I also want the list on Sheet 2 to update any time there’s a change in the column on Sheet 1. For example, if a student was marked here, but was actually absent.

I am tracking information about students. Sheet 1 has each student in their own row, and the columns are different characteristics of that student (for example, their t-shirt size and their grade), as well as their attendance at each session of a class. On Sheet 2, I want to create a stand-alone list of all the students from Sheet 1 who were absent for a given class session. I also want the list on Sheet 2 to update any time there’s a change in the column on Sheet 1. For example, if a student was marked here, but was actually absent.

Thanks Rockin in my previous post to solve the question.

I need to extract the word Trilocale from a complex multiline text like this in a google sheets cell (including n)