Wrap Unique List using frequency

[pto160]

I have a formula returning multiple values, but there is duplicate values in the index list. Can I return an unique list for columns E to H? I am getting the duplicate "Credit" in row 5 to 8.
I am using Excel 2016 at work. Here is what I have.

Book1
	A	B	C	D	E	F	G	H
1	Type	Order	Amount		Results	Results	Results	Results
2	Sale	312800	200		Sale
3	Credit	312900	500		Credit	Sale
4	Sale	312900	400		Credit	Sale
5	Auth	314200	100		Auth	Sale	Credit	Credit
6	Sale	314200	100		Auth	Sale	Credit	Credit
7	Credit	314200	300		Auth	Sale	Credit	Credit
8	Credit	314200	50		Auth	Sale	Credit	Credit
9	Sale	315100	100		Sale	Credit
10	Credit	315100	200		Sale	Credit
11	Auth	318100	200		Auth
12	Auth	320100	500		Auth	Sale
13	Sale	320100	500		Auth	Sale
Sheet1

Cell Formulas
Range	Formula
E2:H13	E2	=IFERROR(INDEX($A$2:$A$13,SMALL(IF($B$2:$B$13=$B2,ROW($B$2:$B$13)-ROW($B$2)+1),COLUMNS($E2:E2))),"")

Here are the desired results:

Book1
	E	F	G	H
1	Results Desired	Results Desired	Results Desired	Results Desired
2	Sale
3	Credit	Sale
4	Credit	Sale
5	Auth	Sale	Credit
6	Auth	Sale	Credit
7	Auth	Sale	Credit
8	Auth	Sale	Credit
9	Sale	Credit
10	Sale	Credit
11	Auth
12	Auth	Sale
13	Auth	Sale
Sheet1 (2)

Cell Formulas
Range	Formula
E2:H4,E5:G13	E2	=IFERROR(INDEX($A$2:$A$13,SMALL(IF($B$2:$B$13=$B2,ROW($B$2:$B$13)-ROW($B$2)+1),COLUMNS($E2:E2))),"")

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H
1	Type	Order	Amount		Results	Results	Results	Results
2	Sale	312800	200		Sale
3	Credit	312900	500		Credit	Sale
4	Sale	312900	400		Credit	Sale
5	Auth	314200	100		Auth	Sale	Credit
6	Sale	314200	100		Auth	Sale	Credit
7	Credit	314200	300		Auth	Sale	Credit
8	Credit	314200	50		Auth	Sale	Credit
9	Sale	315100	100		Sale	Credit
10	Credit	315100	200		Sale	Credit
11	Auth	318100	200		Auth
12	Auth	320100	500		Auth	Sale
13	Sale	320100	500		Auth	Sale
Master

Cell Formulas
Range	Formula
E2:H13	E2	=IFERROR(INDEX($A$2:$A$13,AGGREGATE(15,6,(ROW($A$2:$A$13)-ROW($A$2)+1)/($B$2:$B$13=$B2)/(COUNTIF($D2:D2,$A$2:$A$13)=0),1)),"")

 

[pto160]

Thanks so much. The formula works great. Exactly what I am looking for.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[pto160]

Thanks for your help once again. What I am trying to do is combine the results from column F to column G with "/" as the delimiter and the sort order Auth/Sale/Credit in column H . I imagine I have to write a number of If statements with And or OR statements. So if (or(E2="Sale", F2="Sale". Here it is.

Unique List_Frequency.xlsx
	A	B	C	D	E	F	G	H
1	Type	Order	Amount		Results	Results	Results	Results I want
2	Sale	312800	200		Sale			Sale
3	Credit	312900	500		Credit	Sale		Sale/Credit
4	Sale	312900	400		Credit	Sale		Sale/Credit
5	Auth	314200	100		Auth	Sale	Credit	Auth/Sale/Credit
6	Sale	314200	100		Auth	Sale	Credit	Auth/Sale/Credit
7	Credit	314200	300		Auth	Sale	Credit	Auth/Sale/Credit
8	Credit	314200	50		Auth	Sale	Credit	Auth/Sale/Credit
9	Sale	315100	100		Sale	Credit		Sale/Credit
10	Credit	315100	200		Sale	Credit		Sale/Credit
11	Auth	318100	200		Auth			Auth
12	Auth	320100	500		Auth	Sale		Auth/Sale
13	Sale	320100	500		Auth	Sale		Auth/Sale
Sheet1

Cell Formulas
Range	Formula
E2:G13	E2	=IFERROR(INDEX($A$2:$A$13,AGGREGATE(15,6,(ROW($A$2:$A$13)-ROW($A$2)+1)/($B$2:$B$13=$B2)/(COUNTIF($D2:D2,$A$2:$A$13)=0),1)),"")

Is this possible?

 

[Fluff]

As this is a totally different question, you will need to start a new thread. Thanks

 

[pto160]

Thanks. I will start a new thread.