How to trace and extract the previous different case

Hi,

I have below data(cell array), and I want to do the following,

name	        subname	      status   time
  TV0236.00	VR2300.01     pass	5
  TV0236.00	VI2300.02     pass      7
  TV0236.00	VI2300.03     redo	14
  TV0237.00	VR2300.02     redo	26
  TV0237.00	VR2300.03     pass	9
  TVD897.00	VF2300.01     pass	10
  TVD897.00	VF2300.02     pass	7
  TVD897.00	VF2300.03     redo	17
  TVD897.00	VF2300.04     pass	10
  TVD677.00	VF2300.05     redo	7
  GTY568.00	NU00897.01    redo	12
  GTY568.00	NU00897.02    pass	4
  GTY568.00	NU00897.03    pass	1
  BH0568.00	NU00897.04    pass	7
  GTY968.00	NU00897.05    redo	20

if the time>10, and status is 'redo', then extract the corresponding row of previous different name, I given examples below:

case1:
  row3 time>10, but there is no different name exist previously, the obvious one is row 2

    case2:
    in row4, time>10
    the previous different name is row3

    case3:
    row8 time>10
    the previous different case is row5 etc,

my desired outputs are; rows with time>10, and rows with corresponding previous different name

Out1: rows with time>10

TV0236.00	VI2300.03	redo	14
TV0237.00	VR2300.02	redo	26
TVD897.00	VF2300.03	redo	17
GTY568.00	NU00897.01	redo	12
GTY968.00	NU00897.05	redo	20

out2:rows corresponding to previous different names for time>10

TV0236.00	VI2300.02	pass	7
TV0236.00	VI2300.03	redo	14
TV0237.00	VR2300.03	pass	9
TVD677.00	VF2300.05	redo	7
BH0568.00	NU00897.04	pass	7

Many thanks in advance