# UNIQUE ,INDEX AND IMPORTRANGE

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!

• Welcome. Please edit your question and provide a sample sheet. Your image does NOT relate to your question. – marikamitsos Nov 16 '19 at 6:22
• Provide specific: sample data, desired output, & formula of your currently failing output. – CodeCamper Nov 17 '19 at 23:38

You have grade reading data sourced from another spreadsheet using `IMPORTRANGE`. You want to use that data to analyse the books being read by grade.

There are many ways to achieve this outcome. This answer covers the basics of two methods.

Assume that we have data in a spreadsheet, and this data is imported into the current spreadsheet using `IMPORTRANGE`.

Option 1 - Create a "table" of data

This approach uses two formulas in two adjacent columns:

• `=UNIQUE(D6:D)`: returns unique Grades
• `=JOIN(", ",unique(FILTER(\$A\$6:\$A,\$D\$6:\$D=G20)))`: filters Column A (Book id) and Column D (Grade) and returns results where the grade equals the unique grade number in the adjacent cell

Option 2 - Pivot Table

In this example: