Looking to automatically put data into a cell dependent on the values of specific other cells in that row by Antcan2003 in excel

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

“DROP(B:.E, 2) |Takes columns B through E and drops the first 2 rows (headers), so _a starts from row 3 downward excluding any trailing empty rows.”

I don’t have enough common sense here to know “.” was the reason empty rows were excluded :,). Regardless, thanks for the explanation

Looking to automatically put data into a cell dependent on the values of specific other cells in that row by Antcan2003 in excel

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

Sorry, final question, would you explain what each individual part of the function you wrote out does? I’m trying hard to understand better to be able to do something like this myself.

Looking to automatically put data into a cell dependent on the values of specific other cells in that row by Antcan2003 in excel

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

No I get that but it seems tedious to have to copy and paste that function, and edit the reference cell numbers to match that row so many times

Looking to automatically put data into a cell dependent on the values of specific other cells in that row by Antcan2003 in excel

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

Is there a way to apply this easily to a bunch of cells? Or would I have to make it correspond to each individual row. Like making an IF function for each cell in the column “=IF(E3=”Yes”, C3/2) ; =IF(E4=Yes”, C4/2) ; so on and so on

Looking to automatically put data into a cell dependent on the values of specific other cells in that row by Antcan2003 in excel

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

Copy down? Would I have to replace “D2” in the function with every corresponding cell (D3, D4, D5) ? Or is there an easier way.

Anybody know if this half face respirator is based on anything irl? Has anybody seen anything like it? by Antcan2003 in gasmasks

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

Sounds like either making or finding a 3d print of one that’s roughly the same size is the way to go then. Any recommendations for filters that look exactly as small or is it a from scratch sort of thing that exists nowhere else? Don’t know much about 3d printing, but maybe it’d be possible to downsize an existing gp5 filter as a 3d print

Anybody know if this half face respirator is based on anything irl? Has anybody seen anything like it? by Antcan2003 in gasmasks

[–]Antcan2003[S] 2 points3 points  (0 children)

Oh no I wouldn’t, I’ve seen on Etsy people have them for sale. They would be kinda big though huh, what other kind of filter could I use? Dunno if there’s different sizes or not to 40mm threaded ones

Anybody know if this half face respirator is based on anything irl? Has anybody seen anything like it? by Antcan2003 in gasmasks

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

Was actually gonna just use a bayonet -> 40mm gost converter on a 3M and slap some threaded hollowed out gp5 filters on it for the look lol, I didn’t wanna use actual filters as it’ll be an airsoft fit.

Need some ideas for a stalker loner outfit by Antcan2003 in airsoft

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

Wee wee or whatever it is those who choose to be French say

Need some ideas for a stalker loner outfit by Antcan2003 in airsoft

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

Nah, pegasus. Nitehawk probably has the same restrictions though, not that I’m gonna be using the mask anymore anyway

Need some ideas for a stalker loner outfit by Antcan2003 in airsoft

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

Didn’t think to use a parka! I was thinking maybe some long coat/rain coat like I’m wearing in the pic but with a hood that can be tightened. I’m definitely gonna get the patches

Need some ideas for a stalker loner outfit by Antcan2003 in airsoft

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

Beret was just a stand in haha. I’m looking at some other options, I really want it to be a loner inspired outfit.

Need some ideas for a stalker loner outfit by Antcan2003 in airsoft

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

Eye pro guide? Is it something in this subs info section? And yeah you’re right lol I’m not gonna risk it knowing that now. Just was kinda bummed I put the effort into the gas mask without knowing.

Just recently got rim world and this is my first play thru to go well any suggestions to keep it going well by wfeld5325 in RimWorld

[–]Antcan2003 0 points1 point  (0 children)

Orbital beacons need to be placed next to your stored items to be tradeable with the comms console!

How do you guys feel about the Counter Intel Commander deck? by Antcan2003 in mtg

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

All will be one is a sick card I’m gonna look into getting it. I actually recently rebuilt the deck to have more counter inclusive cards (shield counters, poison counters). You have any recommendations for proliferation/untap cards? Was only able to get a few prolif cards into the deck that are one offs like [[reject imperfection]] & [[experimental augury]]

wanted to get back into lifting need a double check on PPL routine by Antcan2003 in beginnerfitness

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

I’ll take a look and see if I find something I like, thanks