Addind to a column if there is data in another

[djfscouse]

Hi,

In column D is it possible to generate/write I then P then I then P if there is data in column N.

example of required:

column D | Column N
I | 123456A
P | 123456T
I | 1234E6
P | 12L456
I | kjdla23
P | 334llkdi

I hope this makes sense.

Thanks for any help,

David

[JieJenn]

Can you attach a sample data? I think the answer is a yes

[djfscouse]

Attached is an example file, because there is data in column N, I want to generate I in column D and then on the next line if there is data in column N, I want to generate P in column D and it keeps repeating until there is no data in column N.

[JieJenn]

Give me a sample with what the end result will look like

[djfscouse]

Attached is the how it should be after running a macro.

Thanks.

[jeffreybrown]

Do you mean...

In D2 >> =IF(N(N2),"I","")
In D3 and copied down >> =IF(ISBLANK(N3),"",IF(AND(D2="I",N(N3)),"P","I"))

[JieJenn]

Please Login or Register  to view this content.

[djfscouse]

Thanks Jeff, I needed it in a macro.

Thanks JieJenn, worked perfectly.