sort only unique value

[Vishaal]

hi, we have the following sheet and want to sort only unique value

Book1
	A	B	C	D
1	Name	Distributor	Domestic gross	COMBINE
2	Ronny	Paramount	718732821	Ronny (Paramount) (718732821)
3	Rishi	20th Century / Disney	684075767	Rishi (20th Century / Disney) (684075767)
4	Ronny	Paramount	718732821	Ronny (Paramount) (718732821)
5	Thor	411331607	9586754	Thor (411331607) (9586754)
6	Thomas	Universal	376851080	Thomas (Universal) (376851080)
7	Ronny	Paramount	718732821	Ronny (Paramount) (718732821)
8	Angelia	Warner Bros.	369345583	Angelia (Warner Bros.) (369345583)
9	Peter	Disney	343256830	Peter (Disney) (343256830)
10	Jack	Paramount	190872904	Jack (Paramount) (190872904)
11	Thomas	Universal	376851080	Thomas (Universal) (376851080)
Sheet1

Cell Formulas
Range	Formula
D2:D11	D2	=IF(A2="","",A2& " (" &B2& ") " &"("&C2&")")

result sheet

Result in Column F

Book1
	A	B	C	D	E	F
1	Name	Distributor	Domestic gross	COMBINE
2	Ronny	Paramount	718732821	Ronny (Paramount) (718732821)		Angelia (Warner Bros.) (369345583)
3	Rishi	20th Century / Disney	684075767	Rishi (20th Century / Disney) (684075767)		Jack (Paramount) (190872904)
4	Ronny	Paramount	718732821	Ronny (Paramount) (718732821)		Peter (Disney) (343256830)
5	Thor	411331607	9586754	Thor (411331607) (9586754)		Rishi (20th Century / Disney) (684075767)
6	Thomas	Universal	376851080	Thomas (Universal) (376851080)		Ronny (Paramount) (718732821)
7	Ronny	Paramount	718732821	Ronny (Paramount) (718732821)		Thomas (Universal) (376851080)
8	Angelia	Warner Bros.	369345583	Angelia (Warner Bros.) (369345583)		Thor (411331607) (9586754)
9	Peter	Disney	343256830	Peter (Disney) (343256830)
10	Jack	Paramount	190872904	Jack (Paramount) (190872904)
11	Thomas	Universal	376851080	Thomas (Universal) (376851080)
Sheet1

Cell Formulas
Range	Formula
D2:D11	D2	=IF(A2="","",A2& " (" &B2& ") " &"("&C2&")")

 

[Fluff]

i used this formula in google sheet

If you are asking questions for Sheets, then you need to make that clear & post such questions in the General Discussion & Other Applications section of the board.
Not all Excel formulae work in Sheets.

 

[Vishaal]

Thanks Fluff, but its only for sometime not regular,

And we have learn a lot from this forum, now I am very good for most of the formula,

Thanks to mrexcel website