# Re: How to find the most SEQUENTIAL occurring numbers in 1 column

#### rebel123

##### New Member
Re: How to find the most SEQUENTIAL occurring numbers in 1 column

[h=2]how do i sort the numbers in a row in numerical order?[/h]
For example the data looks like this and starts at C2 (I re-sorted it),
so how do I get the data to read "1" on L2, "4" on M2, "10" on N2, "18" on N2, and "26" on O2.
All of those numbers are without parentheses of course. Because the correct numerical
order for these is 1-4-10-18-26

C2 D2 E2 F2 G2 H2 I2 J2 K2
 1 26 18 10 4

<tbody>
</tbody>

#### AlphaFrog

##### MrExcel MVP
Re: How to find the most SEQUENTIAL occurring numbers in 1 column

L2
=small(c2:k2,1)

m2
=small(c2:k2,2)

n2
=small(c2:k2,3)

o2
=small(c2:k2,4)

p2
=small(c2:k2,5)

Last edited:

#### JoeMo

##### MrExcel MVP
Re: How to find the most SEQUENTIAL occurring numbers in 1 column

Copy L2 to the right.
Excel Workbook
CDEFGHIJKLMNOP
212618104 4101826
 April

#### rebel123

##### New Member
Re: How to find the most SEQUENTIAL occurring numbers in 1 column

Copy L2 to the right.
April

 C D E F G H I J K L M N O P 2 1 26 18 10 4 1 4 10 18 26

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:14px;"><col style="width:31px;"><col style="width:21px;"><col style="width:35px;"><col style="width:21px;"><col style="width:32px;"><col style="width:21px;"><col style="width:31px;"><col style="width:14px;"><col style="width:14px;"><col style="width:14px;"><col style="width:21px;"><col style="width:21px;"><col style="width:21px;"></colgroup><tbody>
</tbody>

 Cell Formula L2 =SMALL(\$C\$2:\$K\$2,COLUMNS(\$C:C))

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

STRANGE I TRIED BOTH IN GOOGLE SHEETS AND THE FIRST
FEW CELLS WORKED BUT I GOT THESE SAME RESULTS

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
 1 4 26 #NUM! #NUM!

<colgroup><col style="width: 64px"><col width="64"><col width="64"><col width="64"><col width="64"></colgroup><tbody>
</tbody>

#### Twollaston

##### Board Regular
Re: How to find the most SEQUENTIAL occurring numbers in 1 column

STRANGE I TRIED BOTH IN GOOGLE SHEETS AND THE FIRST
FEW CELLS WORKED BUT I GOT THESE SAME RESULTS

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
 1 4 26 #NUM! #NUM!

<tbody>
</tbody>
I have trouble getting a lot of stuff to work in google sheets.
The formula worked for me in excel

#### AlphaFrog

##### MrExcel MVP
Re: How to find the most SEQUENTIAL occurring numbers in 1 column

I'm guessing you may have omitted the \$ signs in the formulas changing the absolute column references to relative column references. So when you dragged the formulas across, the column references in the formulas changed.