Using clauses if theres growth?

O

omgwtf

New member
Joined
Mar 7, 2013
Messages
3
Reaction score
0
Points
0
Hi! I have an excel table in which I would like to put a '1' as soon as a sequence of numbers starts to increase and a '2' as soon as it starts to decrease. Is this somehow possible? My table looks something like this:

Code: 
[TABLE="width: 121"]
[TR]
[TD="align: right"]11:07:00[/TD]
[TD="align: right"]34,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:07:00[/TD]
[TD="align: right"]34,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00[/TD]
[TD="align: right"]33,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00[/TD]
[TD="align: right"]34,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:09[/TD]
[TD="align: right"]34,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:09[/TD]
[TD="align: right"]35,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:10[/TD]
[TD="align: right"]35,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:10[/TD]
[TD="align: right"]35,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:11[/TD]
[TD="align: right"]34,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:11[/TD]
[TD="align: right"]34,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:12[/TD]
[TD="align: right"]35,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:12[/TD]
[TD="align: right"]36,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:13[/TD]
[TD="align: right"]36,62[/TD]
[/TR]
[TR]
[TD="align: right"]11:13[/TD]
[TD="align: right"]37,12[/TD]
[/TR]
[/TABLE]
[TABLE="width: 121"]
[TR]
[TD="align: right"]11:07:00[/TD]
[TD="align: right"]34,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:07:00[/TD]
[TD="align: right"]34,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00[/TD]
[TD="align: right"]33,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00[/TD]
[TD="align: right"]34,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:09[/TD]
[TD="align: right"]34,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:09[/TD]
[TD="align: right"]35,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:10[/TD]
[TD="align: right"]35,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:10[/TD]
[TD="align: right"]35,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:11[/TD]
[TD="align: right"]34,63[/TD]
[/TR]
[TR]
[TD="align: right"]11:11[/TD]
[TD="align: right"]34,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:12[/TD]
[TD="align: right"]35,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:12[/TD]
[TD="align: right"]36,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:13[/TD]
[TD="align: right"]36,62[/TD]
[/TR]
[TR]
[TD="align: right"]11:13[/TD]
[TD="align: right"]37,12[/TD]
[/TR]
[/TABLE]

I would something to make it look like this:


Code: 
[TABLE="width: 121"]
[TR]
[TD="align: right"]11:07:00
[/TD]
[TD="align: right"]34,63  2
[/TD]
[/TR]
[TR]
[TD="align: right"]11:07:00[/TD]
[TD="align: right"]34,13 
[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00[/TD]
[TD="align: right"]33,63
[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00[/TD]
[TD="align: right"]34,13 1
[/TD]
[/TR]
[TR]
[TD="align: right"]11:09[/TD]
[TD="align: right"]34,63
[/TD]
[/TR]
[TR]
[TD="align: right"]11:09[/TD]
[TD="align: right"]35,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:10
[/TD]
[TD="align: right"]35,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:10
[/TD]
[TD="align: right"]35,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:11
[/TD]
[TD="align: right"]34,63 2
[/TD]
[/TR]
[TR]
[TD="align: right"]11:11
[/TD]
[TD="align: right"]34,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:12
[/TD]
[TD="align: right"]35,13 1
[/TD]
[/TR]
[TR]
[TD="align: right"]11:12
[/TD]
[TD="align: right"]36,13[/TD]
[/TR]
[TR]
[TD="align: right"]11:13
[/TD]
[TD="align: right"]36,62
[/TD]
[/TR]
[TR]
[TD="align: right"]11:13
[/TD]
[TD="align: right"]37,12
[/TD]
[/TR]
[/TABLE]
[TABLE="width: 121"]
[TR]
[TD="align: right"]11:07:00
[/TD]
[TD="align: right"]34,63 2
[/TD]
[/TR]
[TR]
[TD="align: right"]11:07:00
[/TD]
[TD="align: right"]34,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00
[/TD]
[TD="align: right"]33,63
[/TD]
[/TR]
[TR]
[TD="align: right"]11:08:00
[/TD]
[TD="align: right"]34,13 1
[/TD]
[/TR]
[TR]
[TD="align: right"]11:09
[/TD]
[TD="align: right"]34,63
[/TD]
[/TR]
[TR]
[TD="align: right"]11:09
[/TD]
[TD="align: right"]35,13 2
[/TD]
[/TR]
[TR]
[TD="align: right"]11:10
[/TD]
[TD="align: right"]35,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:10
[/TD]
[TD="align: right"]35,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:11
[/TD]
[TD="align: right"]34,63
[/TD]
[/TR]
[TR]
[TD="align: right"]11:11
[/TD]
[TD="align: right"]34,13 1
[/TD]
[/TR]
[TR]
[TD="align: right"]11:12[/TD]
[TD="align: right"]35,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:12[/TD]
[TD="align: right"]36,13
[/TD]
[/TR]
[TR]
[TD="align: right"]11:13
[/TD]
[TD="align: right"]36,62
[/TD]
[/TR]
[TR]
[TD="align: right"]11:13
[/TD]
[TD="align: right"]37,12
[/TD]
[/TR]
[/TABLE]

something like that :)

Anyone willing to help me out?
 
Add this array formula to C2 and copy down

=IF((B1>B2)+1<>INDEX($C$1:$C1,MAX(IF($C$1:$C1<>"",ROW($C$1:$C1)))),(B1>B2)+1,"")
 
thanks a lot!!!
But this only worked for the first row of cells. Any following one just showed as an error. any ideas?
 
Did you enter it with Ctrl+Shift+Enter ? ( array formula)
 
Yes, but still didnt work out. -- What am I doing wrong?
 
Post your workbook with your entry and we will tell you.
 
You must log in or register to reply here.
Back
Top