Help out a company with bad security practices to validate their passwords with Excel!
You are given the following requirements:
– At least six characters long
– No spaces
– At least one number
– At least one special character
Drop your solution in the comments below đ
Our solution:
=IF(AND(LEN(F4)>=6;NOT(ISNUMBER(SEARCH(” “;F4)));
COUNT(FIND({0;1;2;3;4;5;6;7;8;9};F4))>0;
COUNT(FIND($K$4:$K$16;F4))>0);”Valid”;”Invalid”)
