Hi, I want to create a formula that returns a "1" if a criteria is not one of the invalid options. In my sample, Classification (column B) lists all the various transaction classifications. The table at column F lists the Invalid Classifications. Any classification that matches on of the ones listed in the Invalid Table (F) should return a zero in Column D (Valid). All other classifications should return a "1" in column D. Thx for your help
Try this
Formula will return 1 or 0
Formula:
Please Login or Register to view this content.
Last edited by AlKey; 03-12-2018 at 11:32 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
=IFNA(--NOT((MATCH(B2,$F$2:$F$7,0))),1)
or
for Ex2010
=IFERROR(--NOT((MATCH(B2,$F$2:$F$7,0))),1)
Last edited by sandy666; 03-12-2018 at 09:42 PM.
Or:
=--(COUNTIF($F$2:$F$7,B2)=0)
Thanks AlKey. This worked perfectly.
Thanks for your help. So many ways to skin the cat {:]
Thx Phuocam
=if(e106=true,if(iserror(find("-",d106,1)),false,find("-",d106,1)),false)
How do we read and find answer?
Last edited by SatishRazdhan; 03-25-2020 at 08:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks