This problem has been solved. Needs met!
This problem has been solved. Needs met!
Last edited by Tortus; 02-21-2019 at 04:58 PM. Reason: Solved - works great
Try
=SIGN(COUNTIFS(S3:W3,"?*",S3:W3,"<>*~~*"))*(M3="Low")
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thank you sir! This works fine!
If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!
This code works but how do I add in that last piece "Low" or "Lo"?Please Login or Register to view this content.
How about
=SIGN(COUNTIFS(S3:W3,"?*",S3:W3,"<>*~~*"))*(Left(M3,2)="Lo")
Sorry Kev, I wasn't clear. Is there a way to add 2 completely different words in that last part? *(M3="Low","L") or something like "*(M3="Low", "High")
*OR(M3="Low",M3="High")
Thanks kev_, I've beat this thread up enough now I think!
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks