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

 

[kweaver]

Since you don't have 365 (which would make it easy)...if you don't want to resort to VBA, you could copy/paste the D column to F, remove dups via Data tab, then sort (also via Data tab).

 

[AhoyNC]

This link has a formula for Excel 2010.

 

[Kalim Shaikh]

Use Farmula in Sell F2
=SORT(UNIQUE(A2:A11&" "&B2:B11&" "&C2:C11))

 

[kweaver]

Use Farmula in Sell F2
=SORT(UNIQUE(A2:A11&" "&B2:B11&" "&C2:C11))

As my post points out, the OP isn't running 365.

 

[Kalim Shaikh]

Simpler than you might think:

• Click the Data Ribbon Menu
• Select the Advanced Button in the Sort & Filter section
• Fill in the dialog Box, copying the results to another location and making sure you tick Unique records only

 

[Fluff]

@Vishaal what version of Excel are you using? Your profile shows 2010 & 2007, but you have marked post#4 as the solution which uses functions not available in either of those versions.

 

[Vishaal]

Hi Fluff, i used this formula in google sheet, its working on that

 

[Vishaal]

Thanks all for your reply and help.......

Fluff, Kalim Shaikh, kweaver, AhoyNC

 

[Kalim Shaikh]

Thanks all for your reply and help.......

Fluff, Kalim Shaikh, kweaver, AhoyNC

Welcome Vishaal, I am glad to help you.