**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

<tbody>

</tbody>

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>