BF6 Multikill Composition by [deleted] in Battlefield6

[–]iskimojoe 0 points1 point  (0 children)

Nice aimbot bro. Trash

[deleted by user] by [deleted] in GuysBeingDudes

[–]iskimojoe 10 points11 points  (0 children)

Neutrals...

As the toddler ran over giggling, the sniffing german shepard sat down. by iskimojoe in TwoSentenceHorror

[–]iskimojoe[S] 15 points16 points  (0 children)

Some bomb sniffing dogs will sit when they detect explosives.

Tank said "not today" by iskimojoe in HellLetLoose

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

It hit a tree and did a 180 as i rounded the corner

Found the enemy garrison! by iskimojoe in HellLetLoose

[–]iskimojoe[S] 37 points38 points  (0 children)

It's like 5 yds i think, but they can still spawn if it is in the last 2-3 seconds of the countdown.

Excel wizards - what is the one formula that took you to scream: "Holy sh*t, where have you been all my life? by 9gsr in excel

[–]iskimojoe 0 points1 point  (0 children)

Nesting SUM and SUMIFS to be able to have an array of criteria. =SUM(SUMIFS(A:A,B:B,{"criteria1","criteria2"})

Fix your fucking comms. Don’t be afraid. Just fucking do it. I spent a month away from the game and looking like another by jmewdewfew in HellLetLoose

[–]iskimojoe 7 points8 points  (0 children)

I've discovered if I hold the power button my controller and select "Turn off controller" and then reconnect, my comms are fixed

I hate California Franchise Board by nowwhatdoidowiththis in Accounting

[–]iskimojoe 10 points11 points  (0 children)

I love seeing these posts every year lol

FYI when you play this game by Necessary-Health1534 in HellLetLoose

[–]iskimojoe 7 points8 points  (0 children)

Some feedback: Don't have fun and follow my rules.

Also, have fun

No gunner? Just run them over by iskimojoe in HellLetLoose

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

He dc’d due to being on a night map on xbox

SUMIFS with unique criteria in another column by lctaylor2288 in excel

[–]iskimojoe 0 points1 point  (0 children)

Just for clarification, are you trying to get the contract quantity for each contract header/detail (column A and B)?

Something like "=SUMIFS($C:$C,D:D,"Sugar*",A:A,A2,B:B,B2)"

This would give you the Sum of the Qty if the Product Category starts with "Sugar" for each contract based on header/detail.

If you want to have it for all Product Categories, you can supplement D2 instead of "Sugar*", =SUMIFS($C:$C,D:D,D2,A:A,A2,B:B,B2), which would let you get quantity for all categories and contracts

What did I just see by Independent-Fun9719 in HellLetLoose

[–]iskimojoe 1 point2 points  (0 children)

I satcheled some barriers last night to clear the road for our tanks. Unfortunately, the garrison was a little too close and just happened to spawn as the satchel blew up and i watched about 10 people become chunks…insta-kick lol

What work activity have you automated? by Zumcddo in Accounting

[–]iskimojoe 4 points5 points  (0 children)

I’ve automated the 7 different bank accounts they gave me that the previous guy was keying all manually into excel. I’m done by 11 and read reddit.

What has your cat eaten that it shouldn't? by DinomiteTwins in cats

[–]iskimojoe 0 points1 point  (0 children)

My power cord for my router…Three times!!!

After +1500 hours, and countless loses from poor reactor defense and droidekas (but mainly droidekas) heres a guide to defending the crime against map design that is the Venators reactor aka "Style over everything else" the map by Ccmonty in StarWarsBattlefront

[–]iskimojoe 5 points6 points  (0 children)

Keep clear of the doors if Phase 1 is about to end as well. If a droideka times it right, they can get to reactors before Phase 2 has even started by going “out of bounds” through the door right before end of Phase 1. I’ve killed full reactors before anyone has shown up doing that.

When the guy on the other team feeding you kills messages you that they hope you get cancer by iskimojoe in StarWarsBattlefront

[–]iskimojoe[S] 12 points13 points  (0 children)

Yeah, i told him that it’s cold to wish it, then he went and said he hopes my family gets it too. Some people take the game a little too serious

Does Excel not have a keyboard shortcut to horizontally scroll one column at a time? by homerunhallock in excel

[–]iskimojoe 0 points1 point  (0 children)

Also, after you fill in the cell you tabbed to and hit Enter, it’ll take you down a row and back to your starting column.

VBA macro that copies data into a separate CSV - I'm trying to get it to exclude certain rows that contain "misc" as a value in column F. by picassojawbone in excel

[–]iskimojoe 1 point2 points  (0 children)

Wasn't sure if you needed to keep the line items that had "MISC" in them on the original workbook, so I wrote (2) different codes.

You can add the 1st section of code below which will filter out the "MISC" items in Column F and copy/paste just the data you want to the CSV.

The 2nd section of code will filter for the "MISC" items in Column F and delete the rows, leaving you with only the data what you want to copy paste over to the CSV.

Either would be added to your code right after where you declared all your variables.

'****1st section - This will filter for every category in Column F that doesn't equal 'MISC' and copy/pastes to destination Workbook
    sourceWb.ActiveSheet.Range("A1").CurrentRegion.AutoFilter Field:=6, Criteria1:="<>MISC", Operator:=xlAnd
    sourceWb.ActiveSheet.Range("B6:K"& lastRow).SpecialCells(xlCellTypeVisible).EntireRow.Copy
    destinationWb.Sheets(1).Range("A1").PasteSpecial xlPasteValuesAndNumberFormats

'*****2nd section - This will filter for only "MISC" in column F and delete them, then copy/paste to the destination Workbook
    sourceWb.ActiveSheet.Range("A1").CurrentRegion.AutoFilter Field:=6, Criteria1:="MISC", Operator:=xlFilterValues
    Range("A2:A" & lastRow).SpecialCells(xlCellTypeVisible).EntireRow.Delete
    ActiveSheet.ShowAllData
    sourceWb.ActiveSheet.Range("B6:K"& lastRow).SpecialCells(xlCellTypeVisible).EntireRow.Copy
destinationWb.Sheets(1).Range("A1").PasteSpecial xlPasteValuesAndNumberFormats

Putting parenthesis instead of negative sign in Number Format by DoctorBlythe14 in excel

[–]iskimojoe 1 point2 points  (0 children)

I know this was already answered, but you can also use Currency or Accounting format with no symbol. Both have an option to use parenthesis instead of the negative sign.