From: Rick on
Col A = Date field
Col B = Text
Col AB = reference data from col B
Col AB Row 15 = reference data from Row 14

Rows 2 to 14 contains formula - if(A2="",AB1,B2) -- Etc to row 14....






From: Fred Smith on
See your other post.

"Rick" <Rick(a)discussions.microsoft.com> wrote in message
news:02442761-0DCD-432A-9964-56313490EAD4(a)microsoft.com...
> Col A = Date field
> Col B = Text
> Col AB = reference data from col B
> Col AB Row 15 = reference data from Row 14
>
> Rows 2 to 14 contains formula - if(A2="",AB1,B2) -- Etc to row 14....
>
>
>
>
>
>