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

[rebel123]

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
[TABLE="class: cms_table, width: 0"]
<tbody>[TR]
[TD="align: center"]1[/TD]
[TD="bgcolor: #000000"][/TD]
[TD="align: center"]26[/TD]
[TD="bgcolor: #000000"][/TD]
[TD="align: center"]18[/TD]
[TD="bgcolor: #000000"][/TD]
[TD="align: center"]10[/TD]
[TD="bgcolor: #000000"][/TD]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]

​

 

[AlphaFrog]

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)

 

[JoeMo]

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

Copy L2 to the right.

Excel Workbook
	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
April

 

[rebel123]

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

<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>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]26[/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]26[/TD]

</tbody>

Spreadsheet Formulas

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>[TABLE="width: 0"]
<colgroup><col style="width: 64px"><col width="64"><col width="64"><col width="64"><col width="64"></colgroup><tbody>[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]#NUM![/TD]
[/TR]
</tbody>[/TABLE]

 

[Twollaston]

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>[TABLE="width: 0"]
<tbody>[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]#NUM![/TD]
[/TR]
</tbody>[/TABLE]

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

 

[AlphaFrog]

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.