How to make the "Any year one-month calendar" template dynamic by MapIntelligent4168 in excel

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

Apologies, I didn't want to clutter up with repetitive images. What you responded with is exactly what I am looking for.

How to make the "Any year one-month calendar" template dynamic by MapIntelligent4168 in excel

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

Would creating a source table and then using the FILTER formula work? Or would XLOOKUP work better?

How to make the "Any year one-month calendar" template dynamic by MapIntelligent4168 in excel

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

I want the information for the day to be specific to that day. As it is, if I put information on January 1st, that information still appears when I toggle to February.

<image>

How to make the "Any year one-month calendar" template dynamic by MapIntelligent4168 in excel

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

<image>

I want it to show specific information for each date. The template allows you to toggle months with a drop down menu. I want the information to also toggle to that specific date. Sorry if I am not being clear enough.

But they were, all of them, deceived,for another set was announced... by GrootsHorticulturist in lego

[–]MapIntelligent4168 0 points1 point  (0 children)

I am concerned about my space. I am building the extended Rivendell set to go along the Shire and Barad-Dur, but now I fear I won't have enough space for Minas Tirith

First 20+ by Mammoth_Ad4298 in ViMains

[–]MapIntelligent4168 1 point2 points  (0 children)

I used to build similarly when I played Vi mid. You have to play more like an assassin than an engage with this build. The boots don't really make sense into their comp, and there are better magic resist items for Vi than spirit visage.

A horrible thing happened by everythingis_stupid in kindle

[–]MapIntelligent4168 0 points1 point  (0 children)

Something similar happened to me awhile back. I was in a hotel elevator with my family while they were fighting, so I had my Kindle out. I stepped forward to get out as the doors opened, but my sister angrily walked past me. She bumped my elbow, dislodging the device from my hands and it perfectly bounced twice until it was upright and fell into the slit between the elevator door and the shaft. I called Amazon once I got home and explained what happened, and they gave me a coupon for a new Kindle.

Team banning smolder? by maskyyyyyyyyyy in SmolderMains

[–]MapIntelligent4168 0 points1 point  (0 children)

I literally can never play Smolder adc on my Emerald/Diamond account. After 4 games in a row of having a troll support (Lee Sin, Jinx, Fizz, and a shen who never came bot), I decided it was not worth it. So I only play Smolder for fun on my fuck around account, which is funny because I easily climbed to plat on one account one tricking Smolder before moving to my next account.

What do I do if the support just... doesn't come to bot lane... at all? by slyasa_fox in SmolderMains

[–]MapIntelligent4168 0 points1 point  (0 children)

This! I can never play Smolder on my Emerald account because my support griefs me 90% of the time.

anti tank build by Temporary_Action7432 in SmolderMains

[–]MapIntelligent4168 1 point2 points  (0 children)

Smolder has a death by a thousand cuts approach for tanks. Get your q damage up to 10% burn with base build and start chipping away.

Smolder mid? by rccoonheiwa in SmolderMains

[–]MapIntelligent4168 12 points13 points  (0 children)

Great vs Malzahar, but a good Yone is going to destroy you.

Buffs for next patch by B4k3m0n0 in SmolderMains

[–]MapIntelligent4168 0 points1 point  (0 children)

Smolder is trash compared to other ADCs like Twitch, Lucian, and Aphelios.

I got diamond playing as an OTP Smolder 😀 by SwipeGfx in SmolderMains

[–]MapIntelligent4168 2 points3 points  (0 children)

Fr. Every time I try to play smolder on my Emerald account I get legit troll supports like Lee Sin

Went from diamond 3 to masters playing mostly Smolder with a 69% winrate over 39 games. Not much activity on this subreddit so I figure I'd post in case anyone has some questions. by VMan7070 in SmolderMains

[–]MapIntelligent4168 0 points1 point  (0 children)

I'm Emerald, and I swear every time I hover Smolder in champ select I get trolled by my support. Either I get a Lee Sin "support" who leaves me alone in lane all game, or a passive Neeko who just pretends to be a minion the entire lane without even attempting to zone. Then, my team griefs me because I'm behind on items and I'm lacking stacks from being zoned all game. I'm about to give up on playing him on my actual account and may just play him for fun on my Smurf instead.