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:
I would something to make it look like this:
something like that
Anyone willing to help me out?
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?