Check data by formula

[tif007]

I will check data in column AL and column AM.

If column AL have text & column AM not have text ----> column AN write text from Column AL

else column AL have text & column AM have text ----> column AM write text from Column AM

column AL not have text & column AM have text ----> column AM write text from Column AM

Now I use formula as below.
But true some rows

=IF(ISTEXT(AM2),AM2,IF(ISTEXT(AL2),AL2,""))

Please guide me about it.

[JEC.]

There are some values in the empty cells in Column AM.

Select the empty cells and press delete for once

[Glenn Kennedy]

Try this:

=IF(AM2="",AL2,AM2)

copied down

[tif007]

From your formula, If column AL have text & column AM have text (-) ----> column AN write text from Column AL.

Please guide me for solve it.

[Bo_Ry]

Try

=IF(AL2>="a",AL2,AM2)

[tif007]

For your formula some row that correct but some row not correct (Because some column first character have blank)


Please guide me for solve it.

[Bo_Ry]

Last try

=IF(TRIM(AL2)>="a",TRIM(AL2),TRIM(AM2))

[tif007]

No, Correct.
Some rows as false.

Example row 4 and row 11. Data in column AM have data but in column AN write data from AL.

Please guide me for solve it.

[AliGW]

Try this:

=IF(OR(AM2="",AM2="-"),TRIM(AL2),TRIM(AM2))

[AliGW]

Marked as solved - any feedback? Like "thank you", for example?

EDIT: No, nothing. All one-way traffic here.

[TMS]

In response to duplicate thread …

Maybe, untested:

Please Login or Register  to view this content.

copied down.

[AliGW]

The OP will need to continue here on his return. Unfortunately, he has spent today ignoring our rules and moderation, so has been given a holiday.