IF statement for return multiple values

[pto160]

I have a spreadsheet that returns multiple results based on an order number in columns E to G. I would like to combine those results into a single cell with "/" as the delimiter into column H and have the sort order Auth/Sale/Credit. Some of the cells have only one result and the other cells could have 2 or more results based on the order number.
How would you do this? The results desired are in column H. I imagine some sort of IF statement with &"/".

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)),"")

 

[mrshl9898]

=IF(E2="","",E2)&IF(COUNTA(E2:G2)>1,"/","")&IF(F2="","",F2)&IF(COUNTA(E2:G2)>2,"/","")&IF(G2="","",G2)

 

[pto160]

Thanks. Using the Sort<Options<Left to Right only allows you to sort each individual row, which would take forever if you had a 1,000 rows. I was thinking to sort the columns using custom lists so the order would be Auth, Sale, Credit. Row 3 and 4 shows Credit/Sale and Row 9 and 10 shows Sale/Credit.

Is there a way to list Credit/Sale as Sale/Credit?

Unique List_Frequency.xlsx
	H
1	Results
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

Cell Formulas
Range	Formula
H2:H13	H2	=IF(E2="","",E2)&IF(COUNTA(E2:G2)>1,"/","")&IF(F2="","",F2)&IF(COUNTA(E2:G2)>2,"/","")&IF(G2="","",G2)

Is there a way to get rid of the "//" at the end if there is only one entry in the range or one "/" at the end if there is two entries?

 

[pto160]

I set up a lookup table and used your formula as a lookup value to get the results I was looking for.
Thanks for your help.

 

[mrshl9898]

Apologies for missing your replies, have been away from my PC.

Another solution to keep the Auth Sale Credit order:

=IFERROR(IF(AND(OR(IFERROR(MATCH("Sale",E2:G2,0)>0,FALSE),IFERROR(MATCH("Audit",E2:G2,0)>0,FALSE)),IFERROR(MATCH("Auth",E2:G2,0)>0,FALSE)),"Auth/",IF(MATCH("Auth",E2:G2,0)>0,"Auth","")),"")&IFERROR(IF(AND(IFERROR(MATCH("Sale",E2:G2,0)>0,FALSE),IFERROR(MATCH("Credit",E2:G2,0)>0,FALSE)),"Sale/",IF(MATCH("Sale",E2:G2,0)>0,"Sale","")),"")&IFERROR(IF(IFERROR(MATCH("Credit",E2:G2,0)>0,FALSE),"Credit",""),"")

 

[pto160]

Thanks so much. The formula works great.