Hi,

I'm looking for a method to find the previous row for an item, eg:
! A ! B
-----+-----+------------------
1 ! 0 ! Kurt
2 ! 0 ! Jan
3 ! 1 ! Kurt
4 ! 0 ! Peter
5 ! 2 ! Jan
6 ! 3 ! Kurt
7 ! 4 ! Peter
etc

Is this possible with a formule? Ifnot can i write a macro to perform this
operation?

thx

Hedwig