Lurker > AngelsNAirwav3s

Logan could very well be this year's Mad Max and get a BP nod. TDK is the only other super hero movie to reach that level.
---

Hello world!

This movie is stand alone, not in the other timelines.

And it is the best CBM since The Dark Knight
---

Hello world!

QuantumScript posted...

It sucks that the only solution seems to be to turn into a police state. :/

Lets just go shower them with rainbows and unicorns m i rite
---

Hello world!

Sloppy Joe's, buy a can of manwich for sure
---

Hello world!

Probably picked an Ariana Grande concert because she represents a strong, independent, sexual woman, which pretty much goes against everything in their misogynist culture/religion.
---

Hello world!

Lats
---

Hello world!

Her record label released a statement and said her and all her people were ok
---

Hello world!

Female super saiyan?
---

Hello world!

Twin3Turbo posted...

This would also work as simply

=SUM(A1:INDEX(A:A,B1))

or as

=SUM(A1:INDEX(A:10,B1))

The index function is rather powerful and fairly simple to use. It takes an array (in this case, A:A) and uses cell B1 to know how far down to count.

Note that in your spreadsheet, lets say the cells array that you wanted to reference began at A3 and ended at A12, you would have to change the formula to:

SUM(A3:INDEX(A3:A12,B1))

And the reference number (cell B1) could not be a number higher than 10, because that's the most amount of numbers in that array that could potentially be summed (A3:A12 is 10 rows)

You should look up coupling INDEX and MATCH. It'll change your life.

Thanks for the info!

Yeah I used to use excel all the time a couple years ago and remember using index/match instead of vlookup... but I haven't done any excel since until this morning, trying to remember all this stuff
---

Hello world!

VGfreak96 posted...

Use this formula:

=SUM(A1:INDEX(A:A,B1+COLUMN(A1)-1))

Sums number of cells in column A according to what value is in B1.

Amazing!

If you have some time can you give me a quick rundown of how the index function works there to get the other half of the range? If not no worries
---

Hello world!

Really just any help with defining a Cell, I know there is a way.

Like if B1 = 3, I want cell C1 to equal A3. So I can do it multiple ways:

C1: =A3

or

C1: = A'=B1'

Although that isn't right I don't think...
---

Hello world!

So I have a column full of numbers I need to sum up, say A1:A10 are the numbers I want to sum.

However cell B1 has a number like 3 in it. The sum will go in C1.

Now, the tricky part is I only want to Sum the first X numbers of the A1:A10 range, where X = B1.

So if B1 = 3, I only want to sum the first 3 numbers.

Is there an easy way to do this? Basically something like:

=sum(A1:A"=B1")

if that makes sense...
---

Hello world!

Gonna be one of those "omg Trump said he wanted to nuke the entire world in a memo according to inside sources" kind of news week
---

Hello world!

Sir Will posted...

Scorsese2002 posted...

https://www.usatoday.com/story/news/world/2017/05/12/hospitals-england-hit-large-scale-cyber-attack/101592398/

That group has been leaking pieces of more than a gigabyte worth of older NSA software weapons since August.

One of those vulnerabilities the NSA found and didn't report to MS I wonder? It was apparently only fixed in March.

Wow thanks Obama
---

Hello world!

They just think "Wow he really was a wimp"
---

Hello world!

DawnKeyOaty posted...

this is what happens with universal health care, folks

Checkmate socialists
---

Hello world!

Milkman5 posted...

I think it e^x may be the only equation that is a derivative of itself, but don't quote me on that

This, it is like the perfect equation, you start seeing e all over the place in calculus, finance, physics, lots of things
---

Hello world!

Get a real job with benefits
---

Hello world!

Wasn't this guy convinced he would be proven innocent? Lmao
---

Hello world!

The Dark Tower series is massive. This movie looks like it is mostly about the first book, which is a pretty small straightforward tale
---

Hello world!

ZT6 posted...

What the hell do you all do?

Engineer, and started at the company 2 years ago when there were 25 of us, worth $150 mil, then we just went public a year ago for 3 billion, and I got a ton of stock when I joined the company
---

Hello world!

No matter what GPA you get with that degree you are going straight to the fry cooker to start flippin
---

Hello world!

The lock-on system isn't the best either, I lost so many times because I would be looking right at him and pressing lock on, nothing would happen so I couldn't parry, and he rushes in and OHKO's me. Great.
---

Hello world!

Hardest fight in the game tbqh, definitely took me the longest with no master sword.
---

Hello world!

27
$166k
$1.5 million
---

Hello world!

Wow that article makes a ton of assumptions.

First, about that explosion that killed two people, they haven't released any investigation results as to the cause of it. There were two people working on a water heater when it happened, it is pretty likely they didn't shut in the inlet gas hose properly and it filled the basement with gas, and had nothing to do with the well. But we will have to wait and see.

That well is also an old legacy well drilled 25 years ago, and the house was built in 2015, 150' away. The home builders broke the set back law. Nothing to do with current setbacks, which are 500' from homes and 1000' from schools. Colorado just increased setbacks a few years ago, and has the strictest regulations in the nation for Oil and Gas.

It is a shame that these reporters took this tragic story and turned it into some hit piece on corruption, and the two aren't related what so ever.
---

Hello world!

TL;DR: I am so jealous of people who succeed in life more than me
---

Hello world!

averagejoel posted...

"Irish Pride" or "Ukrainian Pride" or "French Pride" would be more comparable to Black Pride

You do know that Africa isn't a single country?
---

Hello world!

Mernardi posted...

ASithLord7 posted...

---

Hello world!

I know several executives at companies ranging from a few hundred million to several billion, and they all eat/sleep/breathe the companies they work for, it is a 24/7 gig
---

Hello world!

JE19426 posted...

Rika_Furude posted...

why does the ceo need a high income? i mean they own the company so at any point they can sell and get a huge payout.

CEO =/= business owner.

CEOs usually get huge ownership perks when they get hired on. And if it is a public company, the salary is just based off industry standard, they make their real money in stock and bonuses. Also if it's a public company you can look on their public filings to see exactly how much all the executives make
---

Hello world!

Funkdamental posted...

FotF's worldwide performance was probably boosted by opening in China on the same weekend as other major markets -- unlike the Force Awakens, which didn't start screening there until several weeks later. FotF took $190m in three days in China, which is clearly a pretty important market these days.

This, Worldwide BO opening/foreign BO opening weekend records are pretty pointless, since they don't all release in the same markets at the same time.

FF had amazing numbers, but in the end it won't touch SW:TFA domestic or worldwide totals.
---

Hello world!

ChromaticAngel posted...

darkprince45 posted...

I've always done my own or have the accountant at work do mine because some army stuff gets complicated


But my girlfriend just barely got her W2 yesterday

If your girlfriend literally got her W2 yesterday that's basically a massive federal offensive.

I am sure she moved, they mailed it to her old address because she never told them she moved, and then she thought like a week ago "Hmm, do I like have to file taxes or something?"
---

Hello world!

I would have been waaaay more surprised if this was an actual nuke topic
---

Hello world!

Best to pass the blame to anyone else other than your own parenting
---

Hello world!

This is the most hilarious article I have read all day
---

Hello world!

butthole666 posted...

Amazon is the reason this is happening tbh so fuck their stupid bitch-asses


I like dealing with customers and shooting the shit with regulars, recommending people other shit they might like, etc

Amazon has cheaper prices and has all sorts of recommendations based on what I have bought in the past and what other people have bought who bought the same item
---

Hello world!

Breath of the Wild is the only game I have ever looked at some stuff because I knew I would be spending a lot of hours in there and there is no tutorial
---

Hello world!

The final battle between Grindelwald and Dumbledore will for sure end with a Depp/Law makeout sesh
---

Hello world!

Maybe Amazon is hiring?
---

Hello world!

Can we please get SBAllen to make GFaqs a safe space, I am getting really triggered right now
---

Hello world!

pres_madagascar posted...

AngelsNAirwav3s posted...

KOTOR 2. Only used Jedi in my party, suddenly there is a boss battle and I am forced to use Atton w/ no supporting party members, against 2 of the toughest mobs in the game.

And then when I have to use a party of scrubs I never used to raid an entire sith temple.

This is why restored content mod made that better. Atton being a Jedi by that point makes that part much easier.

I am pretty sure Atton could still be a jedi at that point if you had enough affection points with him, but if you complete Nar Shadaa in one go then this fight is pretty soon after Atton becomes one, so he is still pretty useless.

And in my first run through I never even realized till the end of the game that you could turn your companions into jedis lol
---

Hello world!

nayr626 posted...

Came out the door.
3 pitbulls start approaching my dog.
Pull him back behind me, so I get attacked rather than him.

Are you insane? 3 Pit Bulls would have killed you easily if they attacked, then killed your dog.
---

Hello world!

KOTOR 2. Only used Jedi in my party, suddenly there is a boss battle and I am forced to use Atton w/ no supporting party members, against 2 of the toughest mobs in the game.

And then when I have to use a party of scrubs I never used to raid an entire sith temple.
---

Hello world!

Can't wait to see how gay they make Dumbledore for maximum pandering factor
---

Hello world!

Butterfiles posted...

They just changed the rule this year so that there's no actually pitches involved anymore (basically the batter is automatically awarded the base) to speed up the game and because some s***ty pitchers struggle with the throw and miss the target

Oh wow I didn't know they changed that.

Also I have a few friends who pitched college level and pro ball, and they all say that throwing intentional walks and also trying to throw the ball to first after a grounder are the hardest things ever lol. Makes sense when they spend 99% of their time winding up and throwing it as hard as they can.
---

Hello world!

I'm happy with this, Brolin can play the super serious character very well, which I think is what the producers were going for most, the exact opposite of Deadpool.
---

Hello world!

Anarchy_Juiblex posted...

AngelsNAirwav3s posted...

you would have only made like 4% of your money.

You say it like 4% in a few days is a bad return . . .

$400 after you risk putting $10,000 in there, and that is before tax, yeah totally worth it lmao
---

Hello world!

jenningsnash313 posted...

AngelsNAirwav3s posted...

And even if you did buy and sell at the peaks, you would have only made like 4% of your money. This was a non news story that #fakenews blew out of proportion again

Nothing cements home an argument like using a hashtag in your statement.

#truthinlife
---

Hello world!