Formula for < or >

[serge]

I'm looking for a formula that would separate numbers in 2 columns.

In column A are the numbers that need to be separated.

In C would be the numbers that are inferior of the previous one and in D the one that are superior.

Thank you. Serge.

Excel Workbook
	A	B	C	D	E
1	1		1
2	18			18
3	6		6
4	3		3
5	5			5
6	12			12
7	10		10
8	27			27
9	36			36
10	44			44
11	21		21
12	1		1
13	7			7
14	15			15
15
Sheet1

 

[markmzz]

I redo the whole table again and now it work fine, It has to be on my side, I'm not qualified like you guys, so the mistakes are surely mine, but that's how I learn how to get a little better with Excel.

Thank you Mark for all your time and effort, Really appreciate it.

Serge.

Serge,

We are all learning here in the Forum.

Thank you for the feedback.

Markmzz