# Populated a column by logical formula using IF

1. ## Populated a column by logical formula using IF

Hi everyone,

I have a worksheet that import from text file, the text file contain 3 column which is populated with text.
The column in the attached excel are column F, G, H. Column F first row contain text value "A", column G and H contain text value continuing through row to row.

Column F the first row contain value in this case "A" only the first row of the import carry value, There are sometimes the import from the text file would show a deference value "F" and blank row below.

I'm trying to populated column E with column F,G,H e.g (ABGCHR result) and when it reach a new value in column F, in this case "F" I need the formula to return e.g (FGGCHR). Not sure if IF formula can archived the result I'm looking for!

Any help much appreciated.

Thank once again for the help.

EughBook2.xlsx

2. ## Re: Populated a column by logical formula using IF

Please show the expected output in a separate column for better understanding

3. ## Re: Populated a column by logical formula using IF

Hi eugh

How about the following, in E6 and copy down:
Formula:
`Please Login or Register  to view this content.`

4. ## Re: Populated a column by logical formula using IF

The output result is in column E in the workbook.

Thank you.
Eugh

5. ## Re: Populated a column by logical formula using IF

Hi Kevin,

Greeting from down-under!!!

Brilliant mate!!! It work perfectly. Can you please explain what the formula under "Z", 255 is doing?

You 're right merged cells are the work of the devil!!! In this case IT there are producing the report.

Once again thank very much

Eugh

6. ## Re: Populated a column by logical formula using IF

Hi Kevin,

Greeting from down-under!!!

Brilliant mate!!! It work perfectly.

You 're right merged cells are the work of the devil!!! In this case IT there are producing the report.

Once again thank very much

Eugh

7. ## Re: Populated a column by logical formula using IF

Hi eugh

The REPT part is finding the last item in the range, ie if it cant find rept("z",255), it will return a approximate match, the last item.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1