SOLVED

Excel Formula

Brass Contributor

Dear everyone,

 

Please suggest me a formula for the following:

 

Thanks in advance.

 

Untitled.jpg

4 Replies

@Oliullah_Siddique 

=COUNTIFS($E$2:$E$4,E2)=3

 

Hi @Oliullah_Siddique

 

Please try: =IF(AND($E$2=$E$3,$E$3=$E$4),"OK","Not OK")

 

Please respond if You require further assistance. I will try My best to be of help.

 

If I was able to help You, please mark My response as answer and helpful.

 

Thank You!

Thanks a lot @Detlef Lewin 

best response confirmed by Oliullah_Siddique (Brass Contributor)
Solution
Thank you very much @Mark_My_Words
1 best response

Accepted Solutions
best response confirmed by Oliullah_Siddique (Brass Contributor)
Solution