For instance if value of column A, cell 1 <> "test" then place "flag" in column B cell 1.
Any help appreciated.
jj
For instance if value of column A, cell 1 <> "test" then place "flag" in column B cell 1.
Any help appreciated.
jj
Perhaps just...
Formula:Please Login or Register to view this content.
Thanks, guess been working on this project too long.
I realize my problem description mistake.
I need to have the "flag" place in a column other than where the formula resides; Say column K.
As an extension of the original issue now want it to test for two variables.
I tried this "OR" statement and got an error:
=if(OR(E1<>"XXX1",E1<>"XXX2"),"Flag","")
Thanks for anything you can do.
JJ
Got this, changed from <> to = and worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks