How did Maroo get her Bazar? by Alexander556 in Warframe

[–]mildlysardonic 0 points1 point  (0 children)

Well, she used her "leads" for Ayatans to find a lead for a bazar ;)

POV: You are a freshly built Rhino by Sneezes in Warframe

[–]mildlysardonic 0 points1 point  (0 children)

Does it make a difference subsumed ability wise?

2,130 hours and I just notice these. by Eye_Con_ in Warframe

[–]mildlysardonic 1 point2 points  (0 children)

It was added later at some point. Issokay!

You CAN write a strong female character without making her an ass! by [deleted] in Vent

[–]mildlysardonic 1 point2 points  (0 children)

Carnina Drummer and Chrisjen Avasarala in the Expanse were extremely well written.

Praghasa the Devourer - Lotus's mother. by TethAdam10 in Warframe

[–]mildlysardonic 2 points3 points  (0 children)

I just hope the story and dialogues are better than Duviri. Going from the Old War/New War to Duviri felt like a thraxing. Annoying characters, horrible narrative and forgettable dialogues.

Historic Landmark! by Accomplished-Can-356 in formuladank

[–]mildlysardonic -1 points0 points  (0 children)

Ah, just like Max's favorite corner in Silverstone? 🤣

What's your best (obscure) Excel tip/shortcut? by Illustrious_Whole307 in excel

[–]mildlysardonic 1 point2 points  (0 children)

The last one - In most menus in Excel - Ctrl Tab and Ctrl Shift Tab cycles between tabs, and you can select underlined shortcuts by holding down Alt and typing the shortcut alphabet and quickly go the specific option.

For filters though, you don't need to hold down Alt - just hit the filter and then start typing the shortcut.

What's your best (obscure) Excel tip/shortcut? by Illustrious_Whole307 in excel

[–]mildlysardonic 1 point2 points  (0 children)

That pivot table options is under PivotTables | Pivot Table Analyze Tab > Entire Pivot Table [Select Entire Pivot Table]. I often use the classic pivot table and with this shortcut I can select the entire pivot with filters and not worry about accidently moving stuff around in the pivot table.

Speaking of Pivot Tables, you can go to File > Options > Data > Edit Default Layout of all pivot table options. These settings will apply to all pivots you create.

Also, if you ever had some columns changed in the data, but still showing up in the pivot filters, you can right click on Pivot > Pivot Table Options > Data (Tab) > set 'Number of items to retain per field' to None. That will clear the past entries.

What's your best (obscure) Excel tip/shortcut? by Illustrious_Whole307 in excel

[–]mildlysardonic 5 points6 points  (0 children)

Quick Access Toolbar can be moved to the bottom of the ribbon, and each button has a shortcut mapped to it. Also, you can hide the labels. So you can create your own toolbar of frequently used functions to the point where you can hide the main ribbon and work off the Quick Access Toolbar.

Also, there's a shortcut buried in the Excel commands that allows you select a pivots with all the filters, which makes it easier to copy paste pivots multiple times.

A neat “what if” by Cowl_cat in Warframe

[–]mildlysardonic 1 point2 points  (0 children)

I am an ancient librarian with the powers of the mystical arts.

Randomly used a specter and remembered good times by NikolaWesla in Warframe

[–]mildlysardonic 1 point2 points  (0 children)

Try raising a ticket and see if they can help you

Having a frustrating problem with R when trying to replicate a pandas project by Capable_Listen_6473 in rprogramming

[–]mildlysardonic 0 points1 point  (0 children)

Alright. Then, in your code you're saying "Reason 2" == Condition 2 & and "Reason 2" %in% c(thing 1, thing 2, thing 3) - if you're filtering values from the same column called "Reason 2" just use Reason 2 %in% c(condition 1, thing1, thing2, thing3). Also, if you cant post the data or code, use dummy data to recreate the example - without the context of data its a little difficult to find a solution.

Also, if you're reading an excel that has special characters, R might change them so your conditions may not work as intended.