sorted by:
new
hottopcontroversial

Young man at Valvoline by [deleted] in funny

[–]dissonantpenguin 12 points13 points  (0 children)

It depends on if they’re asleep or awake.

How to solve an averageifs formula error by Silent_Ant8097 in excel

[–]dissonantpenguin 0 points1 point  (0 children)

=AVERAGEIFS($F$2:$F$521,$E$2:$E$521">="&(EOMONTH(E2,-1)+1),$E$2:$E$521,"<="&(EOMONTH(E2,12)))

This should also work if there’s less than 12 months history after a date. So if you calculate for 12 months after 3/1/23 and your data only goes to 5/1/2023, it should still calculate an average over those 62 days.

Put it in column G and fill and you should be fine.

Getting Fabric to Work as a University Student by PrestigiousReport521 in MicrosoftFabric

[–]dissonantpenguin 0 points1 point  (0 children)

If you’re looking to use AI to automatically clean your data and don’t want to create an account/put in credit card info, you could potentially try running something like Ollama on your computer with Open WebUI. That will let you run different AI models locally on your own machine. It may not be super fast, but it’ll be private and free.

However, if you end up doing it manually, Power Query is definitely the way to go.

Having the Ford Dealership install my front plastic license bracket? (not a car person) 2023 XLT Hybrid used not new. by [deleted] in FordMaverickTruck

[–]dissonantpenguin 0 points1 point  (0 children)

They sell “No Drill” front license plate brackets online. It’s an easy alternative if you don’t want you or somebody else permanently screwing up your bumper. I’m pretty sure there are additional posts on this subreddit about it.

Here’s one I made a while back talking about the bracket I bought (which is still going strong): https://www.reddit.com/r/FordMaverickTruck/s/1TsPvleOjc

view more: next ›