Sort Unique value

[Vishaal]

we have the following data which we want to sort with serial

1. Samsung
1. Samsung
2. Sony
2. Sony
2. Sony
4. Dell
4. Dell
4. Dell
10. TVVS
10. TVVS
20. JBBL
20. JBBL
20. JBBL
20. JBBL

result sheet

1. Samsung
2. Sony
4. Dell
10. TVVS
20. JBBL

help with formula please

 

[ExcelToDAX]

Assuming your data is in Cells A1:A14, how about:

=LET(valuesToSort,A1:A14,UNIQUE(SORTBY(valuesToSort,VALUE(TEXTBEFORE(valuesToSort,".")))))

 

[Joe4]

Vishaal's profile suggests they are using Excel 2007 or 2010. If that is accurate, some of those functions you used in your formula would not be available to them.

 

[Vishaal]

yes Joe4, it's not working, you are right

 

[Joe4]

So which version are you really using?
Excel 2007, Excel 2010, or some other version?

Does your version of Excel have the "Remove Duplicates" functionality found on the Data menu under the "Data Tools" ribbon?
This will change your range into exactly what you show that you want.

 

[MARK858]

With the posted data set and formulas to be entered with CTRL-SHIFT + ENTER

Book1
	A	B	C
2	1. Samsung		1. Samsung
3	1. Samsung		2. Sony
4	2. Sony		4. Dell
5	2. Sony		10. TVVS
6	2. Sony		20. JBBL
7	4. Dell
8	4. Dell
9	4. Dell
10	10. TVVS
11	10. TVVS
12	20. JBBL
13	20. JBBL
14	20. JBBL
15	20. JBBL
Sheet7

Cell Formulas
Range	Formula
C2:C15	C2	=IFERROR(INDEX($A$2:$A$15,MATCH(0,COUNTIF($C$1:C1,$A$2:$A$15),0)),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Vishaal]

thanks mark858, its working

 

[MARK858]

You're welcome, but please note that it doesn't do any sorting as your original data is already sorted.

Also I believe the Remove Duplicates option Joe4 mentioned came out in Excel 2007 and so should be available to you