above is the current code.Please Login or Register to view this content.
I need it to Check a2 , if a2 contains SITE in the text, theN "SITE CALL"
otherwise if a2 = b2, "pass" , "fail"
any help appreciated
above is the current code.Please Login or Register to view this content.
I need it to Check a2 , if a2 contains SITE in the text, theN "SITE CALL"
otherwise if a2 = b2, "pass" , "fail"
any help appreciated
Try:
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
The formula you gave worked a treat and is fine for what i needed. However i just come across another formula that i need aswell. I have tried to write it myself to no joy
IF C2 IS PASS THEN "PERFECTPlease Login or Register to view this content.
OTHERWISE
IF c2 is fail
then search the text in d2 for "No Call" , if no call found then "NO CALLED BY TL"
otherwise "CHANGED BY TL"
You mean?
Please Login or Register to view this content.
thanks mate .. it works fine.. thanks ..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks