No lessons found...
No posts found...
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”)
12 years in market. Admin dashboard included. Courses in Swedish and Norwegian
Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.
Emil har jobbat på Learnesy som produktutvecklare i flera år och ligger bakom flera av Learnesys kurser. Han har en utbildning inom datavetenskap med ett stort intresse för det analytiska och teoretiska. Utöver Finska och Svenska snackar Emil även flytande Excelfunktioner!
Doughnut charts can be a perfect tool to visualize results or percentage of achieved goals.The charts can be a bit...
In this week’s challenge, you need to help your local post office whose package sorting system is broken. The packages...
In our first quiz the task is simple – but not too easy: find the secret codes in a list...
