List customers with specific purchase on 2nd page of an excel spreadsheet

[hsl9999]

I have a spreadsheet with 2 pages. The first page has 3 columns. Column 1 is the customer name, column 2 is the item purchased and column 3 is the item price. We may have from1 to 100 customers a day, so the list could be somewhat long. I have a second page titled "Autobiography". I would like it to list all the customers who purchased that particular item.
So if Sheet 1 looked something like this:

1. John Doe Chocolate $5.00
2. Jane Edward Backpack $25.00
3. Ann Rand Autobiography $10.00
4. Edd Wynn Autobiography $10.00
5. Jack Jones Pencil Pack $2.00

So the second sheet named "Autobiography" should have a list like the following:

1. Ann Rand
2. Edd Wynn

Total Sold: 2

How do I create the second sheet?

 

[AhoyNC]

Something like this.

Autobiography sheet

Book1
	A	B
1	Product	Autobiography
2
3	Names
4	Ann Rand
5	Edd Wynn
Autobiography

Cell Formulas
Range	Formula
A4:A5	A4	=IFERROR(INDEX(Sheet1!$A$2:$A$6,AGGREGATE(15,6,(ROW(Sheet1!$A$2:$A$6)-ROW(Sheet1!$A$2)+1)/(Sheet1!$B$2:$B$6=$B$1),ROWS($A$4:A4))),"")

Sheet 1

Book1
	A	B	C
1	Name	Item	Price
2	John Doe	Chocolate	$5.00
3	Jane Edward	Backpack	$25.00
4	Ann Rand	Autobiography	$10.00
5	Edd Wynn	Autobiography	$10.00
6	Jack Jones	Pencil Pack	$2.00
Sheet1

 

[hsl9999]

Thank you. One question. How do I set the formula to a range of cells as you put in your example. When I placed the formula in Cell A4 I just got the answer "Ann Rand"

 

[AhoyNC]

Assuming I understand the question. You just need to copy the formula down the rows as needed. Also, change the ranges to match your data if needed.

 

[hsl9999]

Thank you again for the help.

 

[kweaver]

Alternatively, fill this down:

Book2
	A
1	Name
2	Ann Rand
3	Jack Jones
Autobiography

Cell Formulas
Range	Formula
A2:A3	A2	=IFERROR(INDEX(Cust!A2:A6,SMALL(IF("Autobiography"=Cust!B2:B6,ROW(Cust!A2:A6)-ROW(Cust!$A$2)+1),ROW(1:1))),"")