classroom

Hi, I am trying to find a formula that will look up numbers of one worksheet and give me totals on another worksheet. The specifics: Column A Column B Column C Room # Class period The enrollment count The catch is that some classrooms and periods are listed twice, as two...

I have a large dataset in a csv file in which I am trying to append text whenever it comes across the words "PREFERRED CLASSROOM PKG." in the cell. Currently the word "null" is found where I want the text to appear. The PREFERRED CLASSROOM PKG. text appears in the beginning or somewhere in the...

Does anyone know if I can use a QR code with an Excel document? I am wanting to use the =now() as a sign in/ sign out for my classroom and allow the students to scan the QR code with their phones. Does anyone have any ideas?

Hello all, I am using Excel 2016, 64 bit. I am having difficulty with a formula. I'm trying to extract a unique list of names based upon a criteria. My formula is pulling only the first two names in the list. My formula is: {=INDEX(Table3[FullName],MATCH(0,IF($D$2=Table3[Classroom]...

I'm trying to create a product page that will return a list of products based upon questions that a customer answers (or that the sales rep fills in). Basically I'm trying to return a value based on the answer to 2 questions (pulled from another sheet), which are in B and C, and the result will...