help with excel data validation So I'm working with Excel's data validation and I'm not too great at the custom formula for data validation. Is there any way to require a cell to have at least one number and one letter, in no particular order? For example, HELLO512 or 3H would be allowed but something like 12345 or HELLO would not be allowed. Also! Would there be any way to prohibit all special characters except for underscores? I'm using Excel 2016 if that matters. Thanks :)
hardest link to level up so i got my lv100 exp potion from the event and im planning on using it on a link mule but im not sure which link to use it on. i know for a fact that mercedes are hard to train, but i've been told that the merc link skill isn't even worth it so?? which class should i use the potion on lol
P/C Ryude Anvil Service I'm trying to sell this right now but idk what the price is. Does anyone know? Preferably MYBCKN but all input is welcome. Also, is the buyer supposed to provide the anvil or am I supposed to provide it? This is all very new to me lol.
Noble Lady's Black Fan Hi, I want to buy a Noble Lady's Black Fan, but I'm skeptical because it is very similar to Elizabeth's Fan (it's basically a recolor), and Elizabeth's Fan is genderlocked to females only. The black fan doesn't state that it's genderlocked, but I just want to make sure before I buy one (never know with Nexon). So does anyone know? Thanks.
Elite Boss Level Range Hi, I just came back from a hiatus and I'm trying to make mesos from elite bosses. I tried going to drakes and hitting the elite boss once before its death, but there are way too many people tracking the bosses there and as a result my screen lags and freezes. I've decided to make a low level character and spawn bosses myself at golems, and it has been working pretty well so far. The flaming golems are level 19 and my character is now 29. Can I still spawn bosses past level 29, or is 10 levels the max level difference?
2015 LoL World Championship So hyped for this :D It's kind of hard to believe that it's starting in only a few days! Which teams are you rooting for and which team do you think will be the champions? I'm rooting for SKT, CLG, and EDG. If the finals come down to SKT and EDG, then I'm going with SKT all the way.
does anyone know cyberlicker from windia? His shop was labeled 'perm nx' and I bought his aqua seraphim, but immediately after buying it I noticed that it was temporary nx I feel terrible now since it was almost all of my mesos.. but yeah does anyone know this guy? I would like to contact him and see if he can do a refund for me (I haven't equipped it yet) ty :(
Developer Letter Glitch This is what happened: I only need one letter to complete the entire letter collection, so I collect a bunch of letters and start going through them. After a while I finally obtain a new letter, but when I check my letter collection it says I'm still missing one. So I assume that I must have miscounted or something and continue opening more letters. I finally obtain a new letter but again, my letter collection still says that I'm missing one. Anyone else experiencing issues with this or is it just me? I really want to finish these letters </3
Coin Shop Pink Bean Balloon Has anyone bought the Pink Bean/Black Bean Balloon mount from the 10th anni coin shop yet? It says "Permanent", and can be used for 10 days after purchase. The 10 days is probably referring to how long you have to use the mount coupon, but I just want to make sure because: All of the other mounts in the coin shop have permanent coupons, but the pink bean balloons are the only ones that have that 10 day thing. Yeah I'm just being super paranoid but want to confirm that it is permanent before I buy it. Thanks!
Postmodern Music Hey guys, I need some examples of postmodern music, in which society/humanity is criticized in some way. Good example is Where Is The Love - Black Eyed Peas. If you all could help me find more songs with significant messages like this that would be appreciated. :D Thank you! Edit: sorry put it in the wrong section by accident
Overrated Hairstyles Which popular hairstyles do you personally dislike? For me it would have to be the super-antenna hair. I was gonna ask this question for eyes but everyone would just say bright eyes.
Black Heaven Damage Skins Are they going to leave the rewards shop anytime soon, or are they going to be in there permanently?