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

rebel123

New Member
Joined
Apr 18, 2017
Messages
17
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
12618104

<tbody>
</tbody>

 

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,135
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
Joined
May 26, 2009
Messages
16,644
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
Joined
Apr 18, 2017
Messages
17
Re: How to find the most SEQUENTIAL occurring numbers in 1 column

Copy L2 to the right.
April

CDEFGHIJKLMNOP
21 26 18 10 414101826

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

Spreadsheet Formulas
CellFormula
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>
1426#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
Joined
May 24, 2019
Messages
221
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>
1426#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
Joined
Sep 2, 2009
Messages
16,135
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.
 

Forum statistics

Threads
1,077,827
Messages
5,336,614
Members
399,093
Latest member
chado4250

Some videos you may like

This Week's Hot Topics

Top