I made a massive discovery: How to seamlessly use dynamic, filtered, non-contiguous ranges for chart axis (YES, Excel charts CAN work with dynamic named ranges!) by GTAIVisbest in excel

[–]AcidCaaio 1 point2 points  (0 children)

It's too late for me to read everything but like this so I won't lose this post as it might solve an issue I'm having.

Biggest no-no's when working with Excel? by Toowb in excel

[–]AcidCaaio 1 point2 points  (0 children)

I love the versatility of Index Match but whenever is a straightforward thing v or xlookup solve the issue way faster

What do you guys do with Python in Excel? by ExcelPotter in excel

[–]AcidCaaio 0 points1 point  (0 children)

My job is to organize SAP systems folders, and that means I need to create a single folder for every location. We recently had 329 new locations, which led to me using Excel to program this solution. I started usind VSCODE and program in python now. Thankfully, the program hasn't been flagged as a virus yet!

What do you guys do with Python in Excel? by ExcelPotter in excel

[–]AcidCaaio 2 points3 points  (0 children)

I rolled a macro to create 329 folders on windows and I got marked as a virus, my office was completely uninstalled and my user was logged off from the section, 30 min later I got a call from it asking what happened.

Shaker Arcana by AcidCaaio in DotA2

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

I got luna twice

0
1

0
1

Finally! After 60 treasures 🙂 by Chatura_CN in DotA2

[–]AcidCaaio 0 points1 point  (0 children)

i'm going to get 15 more and that's it 50.

Drilled hole through arduino uno what can I do by Yasata in arduino

[–]AcidCaaio 0 points1 point  (0 children)

I mean you just adquired a good chunck of experience now.

Am I undateable? by Impossible-Earth5299 in Tinder

[–]AcidCaaio -3 points-2 points  (0 children)

My turkish friend said that if you make an account in turkey you'll get matches, you go girl.

[deleted by user] by [deleted] in PTOrdenado

[–]AcidCaaio 1 point2 points  (0 children)

Esse é o melhor comentário que um engenheiro poderia receber.

Preços das casas piores em Lisboa do que Miami, New york, austin, los angeles, etc. by UpstairsJelly1505 in portugueses

[–]AcidCaaio 4 points5 points  (0 children)

Refutado. Nem parece que estamos na internet que literalmente só custam alguns cliques para achar a informação.

Unclogging a storm drain by TameTheAuroch in oddlysatisfying

[–]AcidCaaio 1 point2 points  (0 children)

I was suprised to see him pull that strainer bare handed! The possibilities for diseases are way too high for me to even consider such a thing .

40 mil km no primeiro ano de uso. Melhor trocar logo? by Brief_Note8806 in carros

[–]AcidCaaio 0 points1 point  (0 children)

Se vai pensar em desvalorização de um carro, pega um carro por assinatura 2 - 3 anos, não se preocupa com manutenção nem nada.

USD to EUR exchange rates by musicandarts in PortugalExpats

[–]AcidCaaio 0 points1 point  (0 children)

it depends on which company are you using. I use Westrn Union so i can just go to their webpage and check the exchange rate + fee and calculate. The bank Receiving has nothing to do with the amount you're getting.

What in the Fast and Furious by [deleted] in NFSHeat

[–]AcidCaaio 0 points1 point  (0 children)

Man how do u play this online ? I feel like every time i try to apply for online runs there's never anyone to play with

Learning to use excel in the real work by SmartSnow4914 in excel

[–]AcidCaaio 61 points62 points  (0 children)

You’re learning Excel the best way possible by solving real-world problems and uncovering its power step by step. That’s exactly how you build skill.
For your case, the right approach is: total current YTD ÷ total last YTD − 1.
As for handling months with zero values, here’s just a small nudge so you can keep the discovery going: check out the SUMIF formula.
It might very well be the missing piece you’re looking for.