Excel - How to check a specific Text in multiple column cells and return a text

[MSAli]

I have have 4 columns (E, G, I, & K - note each have a column in-between). Cell in Row 7 in these columns contain a text as follow:

E7=Complete G7=Complete I7=Complete K7=Complete

All I want to do is to check is the text in all the four cells is the same (i.e. "Complete").
If its TRUE, then in cell (L7 = Complete) is displayed.

Can someone help, thx!

[alansidman]

In L7 =if(and(E7=G7,E7=I7,E7=K7),"Complete", "")

[Vraag en antwoord]

or

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[MSAli]

Works like a Charm much appreciated, Thx!
I was not using the AND function.....

[MSAli]

It works Thanks!
But when I copied it across, when the text is matching but is not "Complete" its still showing Complete.
Is there a way to only check for "Complete" across the 4 column cells.
Thanks

[Vraag en antwoord]

Use the $ sign to fix the columns. Otherwise place the file. Or an example of it.

[MSAli]

Hi Alan,
I used the formula and it works for the example (row 7) above.
When its copied down, though if the cells have a the same text (not "Complete") it prints "Complete" in L7.
e.g. E8=Open G8=open I7=Open K7=Open - in this case L7 should be blank.
I'm new to the form so sorry for the repetition!

[Vraag en antwoord]

If you only focus on 1 helper, then you have to wait for the answer.

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[MSAli]

Sample file attached.

[Vraag en antwoord]

Well, reading is not your best art. See # 3 1st option.

[MSAli]

Doesn't work as the there are other columns. Please see attached file!

[Vraag en antwoord]

Have you tried it?

[alansidman]

My amended code based upon your latest post

=IF(AND(B2="Completed",D2="Completed",F2="Completed",H2="Completed"),"Completed", "")

[Bo_Ry]

Please try at I2
=REPT("Completed",COUNTIF(B2:H2,"Completed")=4)

[MSAli]

Thanks Alan, it works.
Have a nice day!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.