Formula to identify and delete dates

Capture.PNG
Hi I have to identify and delete dates that are previous of a later step.
Assume we have a table with 6 columns each column is a consecutive step.



Columns- A B C D E F
Step 1 Step 2 Step 3 Step 4 Step 5 Step 6

1/1/14 2/2/14 3/3/14 4/4/14 3/1/14 6/6/14 - in this line i would like to delete date on column E because its a previous date to the step before and Keep F .
1/1/14 2/2/14 . . 4/4/14 1/1/14 - sometimes there are just no dates and I have a point but I want to Keep column E but dont want column F.

I made a couple of If formulas that present a table besides the dates table with Good and Delte. And another table besides that if the table states Good it copied the date if it said delete it wont copy it. So i would have a new table with the dates, without the delete ones.

That was my approach but there are so many special cases that they get messed up!!!


HELPPP PLEASEE!!! THANK YOUUUUU!!!

in G try

Please Login or Register  to view this content.

in H to L try

Please Login or Register  to view this content.

then copy and paste G to L by value.

A

B

C

D

E

F

G

H

I

J

K

L

1

1/1/2014

2/2/2014

3/3/2014

4/4/2014

3/1/2014

6/6/2014

=A1

=IF(A1=".",B1,IF(B1=".",".",IF(B1<A1,".",B1)))

=IF(B1=".",C1,IF(C1=".",".",IF(C1<B1,".",C1)))

=IF(C1=".",D1,IF(D1=".",".",IF(D1<C1,".",D1)))

=IF(D1=".",E1,IF(E1=".",".",IF(E1<D1,".",E1)))

=IF(E1=".",F1,IF(F1=".",".",IF(F1<E1,".",F1)))

2

1/1/2014

2/2/2014

.

.

4/4/2014

1/1/2014

=A2

=IF(A2=".",B2,IF(B2=".",".",IF(B2<A2,".",B2)))

=IF(B2=".",C2,IF(C2=".",".",IF(C2<B2,".",C2)))

=IF(C2=".",D2,IF(D2=".",".",IF(D2<C2,".",D2)))

=IF(D2=".",E2,IF(E2=".",".",IF(E2<D2,".",E2)))

=IF(E2=".",F2,IF(F2=".",".",IF(F2<E2,".",F2)))

3

.

2/2/2014

.

.

4/4/2014

1/1/2014

=A3

=IF(A3=".",B3,IF(B3=".",".",IF(B3<A3,".",B3)))

=IF(B3=".",C3,IF(C3=".",".",IF(C3<B3,".",C3)))

=IF(C3=".",D3,IF(D3=".",".",IF(D3<C3,".",D3)))

=IF(D3=".",E3,IF(E3=".",".",IF(E3<D3,".",E3)))

=IF(E3=".",F3,IF(F3=".",".",IF(F3<E3,".",F3)))