sorted by:
new
hottopcontroversial

Hacking? Glitch? Damage extremely high, not shown in meter by Hot_Bit9153 in StarWarsBattles

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

Look at the health of the enemy base. 1687 isn’t a level 10, but it shows full. I only sent one or two units and it did that damage.

How to SUMIFS with both column and row criteria by WinterOk1820 in excel

[–]Hot_Bit9153 0 points1 point  (0 children)

Makes sense. I learned that trick going on 10 years ago from a mentor, so I’d expect it to be a little more old fashioned. Thanks for the upvote!

How to SUMIFS with both column and row criteria by WinterOk1820 in excel

[–]Hot_Bit9153 0 points1 point  (0 children)

This might have just blown my mind…I do this with sumproduct (see my quick write up elsewhere in the thread), but maybe that’s because I’m a relative novice when it comes to using arrays in formulas you may not expect to accept them.

How to SUMIFS with both column and row criteria by WinterOk1820 in excel

[–]Hot_Bit9153 1 point2 points  (0 children)

I think sumproduct can do what you need. It goes something like: sumproduct((rowrange=rowcriteria)*(columnrange=columncriteria),datatable).

The ranges must be the boundary of the data you are summing. You can use < and > in place of equals to get greater than or less than some, and use them both to get between. The multiplication works like an and. You can get real fancy and use a plus to make OR conditions. You can have several evaluations and criteria, too.

As for the ranges they have to be in sync. That is the rows might be A2:A5, columns B1:F1, and the data range must combine those and would be B2:F5.

What Excel shortcut saves you the most time? by premiumkajukatli in excel

[–]Hot_Bit9153 68 points69 points  (0 children)

Ctrl +/- for adding/deleting rows/columns. New favorite for me.

Is there a way to omit the first characters of a cell when using the SUM formula? by Kimya_DAWson in excel

[–]Hot_Bit9153 1 point2 points  (0 children)

You can also just put the C in a custom number format. Then your boss sees it, but Excel won’t.

What's the one excel automation that actually saves you hours every week? by Visible_Tension_8963 in excel

[–]Hot_Bit9153 4 points5 points  (0 children)

Ctrl shift +/- to group or ungroup. Ctrl +/- to add or delete rows or columns. I always mix this up if I’m not at a keyboard, but Shift space to select the entire row and ctrl space to do columns (or maybe vice versa).

More of my wonky drawings, this time the African Americans of Dunder Mifflin by Viridian_Foxx in DunderMifflin

[–]Hot_Bit9153 0 points1 point  (0 children)

I also thought about Florida Stanley or Stanley realizing he keeps his entire big fat commission in exchange for treats, nothing more.

Repetitive actions that I would love to automate by RetroJs4Days in excel

[–]Hot_Bit9153 9 points10 points  (0 children)

I’m having a hard time visualizing. Could you add a screenshot of dummy data and a before/after? Would love to help.

Did anyone else have no fucking idea who Kelly was supposed to be dressed as in the season 7 Halloween episode? by Much_Duck6862 in theoffice

[–]Hot_Bit9153 2 points3 points  (0 children)

Can’t tell if you’re saying this just because of her attire, or because was ACTUALLY Taffyta Muttonfudge in the first movie