GREAT!!! THX!!!
"Jason Morin" wrote:
Put 0 in A1 (it'll always be 0), then copy the formula
below into A2, press ctrl + shift + enter, and fill down
the column:
=IF(COUNTIF($B$1:B1,B2),SMALL(IF($B$1:B1=B2,ROW
($B$1:B1)),COUNTIF($B$1:B1,B2)),0)
HTH
Jason
Atlanta, GA
-----Original Message-----
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
.
|