Conditional copying

[laurafv]

Hi,

I would need help copying values according to some conditions.

Each row in my file describes a country and a year. I have data for some years; I would need a way to copy these observations to the following years until there is a new value (conditional to being same country). On the other hand, if there was no value for that country, I would need a ".". Do you think this can be done? I hope the attached file clarifies my question.

Thanks a lot!

[laurafv]

sorry, I had forgotten the attachment

[TonyB51]

Hi,

I hope this is what you were looking for.


Cell E3 =IF(A3=A2,IF(C3="",E2,C3),IF(C3="",".",C3))


Refer to attached sheet.

Cheers

Tony

[shg]

Or similarly, in E3 and copied down, =IF(C3<>"", C3, IF(A3=A2, E2, "."))

[laurafv]

Thanks a lot!