I am stuck. I use the import range to get a set of data however now I need to the unique values that that matches the import range that I have.
Say for example below is randome sample. I have import range the information but now I need to find the grades for Book 1. Since there are multiple grades reading book 1, what formula do I use to find the grades(Is it unique(filter(importrange?) and possibly have them in one row and how do I find this for each book? Any help would be appreciated!