Help! Excel formula - Pulling from data to another sheet

[Shetara]

Hello,

I want to pull names connected to a category. I need help pulling all names associated with this category. The name column also grows throughout the year. Is there a formula to use that will pull all names associated to the column?

OR Can I make a pivot table and then extract the names aligned to the category to a new excel sheet?

Example:

Name	Category
Birtha	Art Class
Garry	Math Class
Ren	Art Class

<tbody>
</tbody>

 

[Aryatect]

Hi, This is 1 option:

Taking more details from https://www.mrexcel.com/forum/excel-questions/1107193-simple-formula-excel.html

Book1
	A	B
1	Data Source:
2	Name	Class
3	Ron	Math
4	Amy	Science
5	Zack	Math
6	Alicia	Math
7
8
9	Desired Outcome:
10	Class:	Math
11
12	Ron
13	Zack
14	Alicia
15
16
17
Sheet3

Cell Formulas
Range	Formula
A12	=IFERROR(INDEX($A$3:$A$6,AGGREGATE(15,6,(ROW($A$3:$A$6)-ROW($A$3)+1)/($B$3:$B$6=$B$10),ROWS(A$12:A12))),"")