Formula to copy paste from row above and apply down

[jw01]

Hi all

In my worksheet, i have cities listed in column C, along with sales ppl name. The cities are "Amsterdam, Bangkok" etc.

In column F, i simply want to reference what city it is, so if i.e. city is in C9, in column F11 = C9, F12 = F12 etc

I have attached my sample in the attached.

TO give you an example, cities are listed in C9, C274, C374 etc. there is no logical sequence, so not sure how to apply a formula?

thxs for the help!

[chandy123987]

I applied the formula in column G. Use If function to get the desire result. Hope this will help you.

-----------------
If solved, click * Add reputation

[Sadath31]

Hi

Formula in G1 =IF(AND(ISBLANK(A9),XOR(ISBLANK(A9),ISBLANK(C9))),C9,G8) and copy down

[Sadath31]

Hi

alternate formula in G1 =IF(XOR(ISBLANK(A9),ISBLANK(C9)),C9,G8)