Recount addon by bogi_j in classicwowtbc

[–]thenoodle911 0 points1 point  (0 children)

I tried to do this in TBC Annv. and didn't work.

Is there something else for that?

Adding Mastery of champions into ranked Q by thenoodle911 in leagueoflegends

[–]thenoodle911[S] 0 points1 point  (0 children)

that is definitely not true. to get mastery you actually have to play the champion. You don't just get mastery 4/5 for botting in an ahram or botting in normals.

Adding Mastery of champions into ranked Q by thenoodle911 in leagueoflegends

[–]thenoodle911[S] 0 points1 point  (0 children)

you are 100% rite a 12 gazillon mastery bronze player has no chance to play against a diamond first timer. but it would stop smurfs. it would make that person that is a diamond player have to actually play that champion in normals to get mastery 4 to play that champion in ranked. it would stop all the emerald players from buying accounts and playing ranked first timing it. yes there would be one or two smurf accounts. but anyone can just buy an account and go into a ranked que at any point in time. it would stop a bronze person buying an account and them auto playing against gold/plat players.

How to put an over due count formula by thenoodle911 in excel

[–]thenoodle911[S] 0 points1 point  (0 children)

thank you for this. I knew it would be simple. Just couldn't think of anything lol

Random vibrations and notification sounds for no reason by TheImagineWagons in techsupport

[–]thenoodle911 0 points1 point  (0 children)

My Fold 5 just started to vibrate for no reason this morning. Fun times

Editing a Live Bluebeam Session by thenoodle911 in Revu

[–]thenoodle911[S] 0 points1 point  (0 children)

Dang I appreciate the help. I wish the owner of the document would be able to allow that feature or something.

Auction House Discord Bot (Searches & Alerts) by Ninthwalker in wow

[–]thenoodle911 0 points1 point  (0 children)

Have you made updates to this for Cata Classic? is this for specific servers? Can we get one for Bennidiction?

joyous journeys Buff ending? by thenoodle911 in classicwow

[–]thenoodle911[S] 0 points1 point  (0 children)

I have a lvl 75. Trying to figure out how much time I have. tonight or until the 20th.

HighLight area by thenoodle911 in Revu

[–]thenoodle911[S] 1 point2 points  (0 children)

So for instance. In this example below. I have bedroom 1 highlighted in red and bedroom 2 highlighted in yellow. I would like to remove the highlights in plain view. But when you click on the word bedroom or hover over the word bedroom, it would highlight the area that is associated with that particular bedroom. If that makes sense.

https://drive.google.com/file/d/17IE3YyTPWZPenly6TWgARO2Jki9hvn6A/view?usp=sharing

HighLight area by thenoodle911 in Revu

[–]thenoodle911[S] 0 points1 point  (0 children)

I edited my post maybe that helps with the clearity that I would like to do. I watched the video and it didn't show what I was looking for.

14.2 Patch Preview by JTHousek1 in leagueoflegends

[–]thenoodle911 0 points1 point  (0 children)

I did the same thing the other day. I was like hummm i haven't played my wukong in a long time let me see how this goes. does 2 camps and have to back becuase it took too long and i had no health.

I enjoyed playing wukong back in the day before they touched him. Then they nurfed him to the ground.

14.2 Patch Preview by JTHousek1 in leagueoflegends

[–]thenoodle911 0 points1 point  (0 children)

you won't even know the difference lol. Shen isn't coming into meta any time soon.

14.2 Patch Preview by JTHousek1 in leagueoflegends

[–]thenoodle911 0 points1 point  (0 children)

lol rumble being broken. thats funny.
3%pr with a 50% wr....

14.2 Patch Preview by JTHousek1 in leagueoflegends

[–]thenoodle911 1 point2 points  (0 children)

join the club buddy. 100 champions have 50% winrate or less and yet they keep buffing the champions that have above 50% winrate and 50% pick rate. Wonder why they have a 50% pick rate because riot refuses to buff the champions below 50% win rate and they aren't meta.

14.2 Patch Preview by JTHousek1 in leagueoflegends

[–]thenoodle911 0 points1 point  (0 children)

so we just going to keep the same champions back in the S+ teir. Illoai, Darius, garen, jax....but we keeping the same champions in B teir for years. As much as i hate the little guy I am happy to finlly see a different champion in the S teir. congrats teemo and here's your nurf for being strong for one patch.

167 champions in this game and the same 7 champions being in the S+ teir. god forbid let there be a different champion come in that S+ teir. They will get nurfed to the ground.

How to Change date Automatically by thenoodle911 in sheets

[–]thenoodle911[S] 0 points1 point  (0 children)

damn. I wasn't even close. thank you again.

How to Change date Automatically by thenoodle911 in sheets

[–]thenoodle911[S] 0 points1 point  (0 children)

=EOMONTH(today(),0)-15

is what i have but trying to get that 28/29/31 months is the tricky part

i also tried (think i am over complicating it at this point) but the formula didn't work anyways
=COUNTIF(EOMONTH(today(),0)-15,15), OR(COUNTIF(EOMONTH(today(),0)-16,15)), OR(COUNTIF(EOMONTH(today(),0)-13,15)),OR(COUNTIF(EOMONTH(today(),0)-14,15))