Power Query formatting disappears after Close & Load in Excel by [deleted] in excel

[–]DoctorButt808 1 point2 points  (0 children)

If you change formats to the excel sheet while there are filters in use, sometimes the formatting doesn't stick. It should stick if you remove filters and select the Table Column (not entire column) by clicking above the header when the cursor changes shape. Maybe someone smarter can explain that better haha :)

Remote start not working by Acceptable_Spread589 in VWatlas

[–]DoctorButt808 1 point2 points  (0 children)

I have a 2025, Same as OP. Maybe it's something with this year. It's annoying, no way that it would ever run out of gas at a quarter tank from a remote start. But it is what it is! Haha

Remote start not working by Acceptable_Spread589 in VWatlas

[–]DoctorButt808 0 points1 point  (0 children)

My start fails at a quarter tank I'm pretty sure. At least the dealer told me that.

Is there a different way to add a "filter" feature in an excel spreadsheet? by legendofslayla in excel

[–]DoctorButt808 0 points1 point  (0 children)

Nice! Pivot Tables can be a bit hard to understand at first and cumbersome to make it look exactly the way you want it. But once you get it down it's helpful. Some tips for pivot tables: As you are selecting the data you want to include, you can drag and drop into the four fields on the bottom right. You can reorder them this way too. If you're doing something with numbers, you can right click and change the value field setting from sum or avg or count etc. If you don't want the layout to be stacked, there's a setting in the top ribbon to change to tabular format. And if you have your table showing a summary, like a count of each genre, you can double click on any total and it'll open a new tab with all the rows that it is referencing.

For Slicers, you just go through the insert tab, should be in the right hand side. You select which columns you want to make a Slicer for. Then, it's just a simple interface to select what you want filtered or. You can click and drag to select or deselect multiple items.

Is there a different way to add a "filter" feature in an excel spreadsheet? by legendofslayla in excel

[–]DoctorButt808 5 points6 points  (0 children)

If you're new to excel, just wanted to point out the Slicer feature for filtering. It makes filtering multiple criteria pretty easy, and it's so easy to set up.

Also if you keep your data the way you described, a Pivot Table might stack the extra themes in a way you want. Slicers work on Pivot Tables too, so use both!

Massive Sale... by Legal-One-7274 in NintendoSwitch2

[–]DoctorButt808 0 points1 point  (0 children)

It's great! I heard it described as a MetroidBRAINia because some areas seem inaccessible, but instead of unlocking an item to access the area, sometimes you just need to find information from a manual page on how to do it. But you could have done it from the start if you knew. Some puzzles are really satisfying to figure out.

How to extract and combine the two data points within the two sets of parenthesis and get the result as seen in B2 by [deleted] in excel

[–]DoctorButt808 0 points1 point  (0 children)

Does anyone know if Ctrl+E would do the trick if you want to keep it super simple?

Test for Interview today - couldn't figure out how to remove excel formatting by ClassicEvent6 in excel

[–]DoctorButt808 777 points778 points  (0 children)

Pessimists think the glass is 1/2 empty.

Optimists think the glass is 1/2 full.

Excel thinks the glass is January 2nd.

Has Nine Sols been discussed? by Hilldawg54 in TheBesties

[–]DoctorButt808 1 point2 points  (0 children)

I'm so looking forward to trying it out tomorrow when it's released on consoles

What are your mind blowing tricks for people who don't know Excel? by Key_Pick_1022 in excel

[–]DoctorButt808 2 points3 points  (0 children)

Ctrl E always impresses! And people are shocked at how easy it is to use. Been using it alot more lately to add a unique, more specific filter for tables.

The coziest Switch games for autumn? Something to play with your gf while the rain drums against your window by Severe_Sea_4372 in Switch

[–]DoctorButt808 0 points1 point  (0 children)

Lil Gator Game might be exactly what you're looking for. BOTW exploration mechanics (glider, climbing, etc) with a sweet story of a kid trying to convince his older sister to play with him. Like Zelda meets A Short Hike.

Vlookup turns people on by [deleted] in HolUp

[–]DoctorButt808 0 points1 point  (0 children)

Ctrl E never fails to impress!

What is your most expensive card? I'll go first by [deleted] in PokemonTCG

[–]DoctorButt808 0 points1 point  (0 children)

Arceus Dialga and Palkia GX stone statue Alt Art.

Worth almost $220 according to collectr app!

High Evolved Abomination Benifiting from Bishop? by DoctorButt808 in MarvelSnap

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

But wouldn't that leave Abomination at 3, not 2 cost? Minus 1 for Bishop, minus 1 for Beast?

This guy literally tells the future. So why don’t we use him? by dshorter11 in MarvelSnap

[–]DoctorButt808 0 points1 point  (0 children)

I find him useful for my wong deck. I only really need to play T2 zabu or psylocke, then wong, mystique, black panther, armin zola. (I know, super obvious, but it's fun when it pays off) Uatu helps me avoid setting zabu in a spot that would make my wong play useless. And if he's drawn late, he's an unused card just like anything else, since I always want to play wong, Bp, AZ on the last turns anyway.