formula to sort and delete duplicates

[jococourthouse]

Hello,

I am looking for a way to sort and delete duplicates.

example below

number	sorted and delete duplicates
1	1
2	2
3	3
1	4
2
4
4
4
2

<tbody>
</tbody>

The column labeled number needs to be left the same.

Thanks for any help!

 

[Eric W]

Welcome to the Board!

Depending on your needs, it might be easiest to use some of the built-in functions of Excel. Use copy/paste to copy column A to column B, then use the Remove Duplicates tool from the Data tab, then use the Sort tool. Once you get the hang of it, you can do it in a few seconds. This could be automated by VBA if you want.

You could also use a formula to do that. For example:

Excel 2012

	A	B
1	number	sorted and delete duplicates
2	1	1
3	2	2
4	3	3
5	1	4
6	2
7	4
8	4
9	4
10	2
11

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula B2 {=IFERROR(INDEX($A$2:$A$10,MATCH(0,COUNTIF($A$2:$A$10,"<"&$A$2:$A$10)-SUM(COUNTIF($A$2:$A$10,$B$1:$B1)),0)),"")} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

Hope this helps!