Rayvin

Just for the record, this stuff worked and I have it set up now. Thank you. I have a new issue though. I have a table that has each individual Product on separate rows. The Product consists of variable Components that can be selected through drop down boxes in columns D:Z. I am tracking the number of Products sold in Column C. I have an inventory sheet that tracks stock levels for all variable Components, and I want it to update automatically if a Product is sold, based on the variations of Components associated with it. This means I need a formula which will look across D:Z for all rows, identify the Component, and then multiply it by the number of Products sold (Column C). The problem is that I only want it to multiply it if it actually exists as a variable option for that Product. So for example: Product A = Component A + Component B + Component C Product B = Component B + Component C Product C = Component A + Component C Product A Sales: 1 Product B Sales: 1 Product C Sales: 1 So I want the stock sheet for Component C to count all the sales totals because it is used in all Products. However, Component B I only want it to count Product A and B. Because the Components are all set to a stock value of 1 when they are associated with a Product, it would also be feasible to simply Sum the sales column where a Component exists on the same row. But for the life of me, I can't make it happen. It keeps setting it to zero.

Lying coward afraid to take responsibility for his stupidity. There is no logical argument at any stage for that position. May went in ultra hard to begin with, and the "Remain politicians" turned out for her vote in sufficient numbers that if the hard-core leave politicians had joined in, she would have won. It is on them, entirely. No deal is happening only because of leavers. Remainers, no matter what they think, were deliberately made completely powerless throughout.

Why now? Why is the penny finally dropping now when we are absolutely past the point of no return. Everything said there has been transparently obvious since day 1.

Loads of comments from gammons in there threatening never to go back to Scotland though. The other side of the same fucking coin as the muppets in the video. When they're running around sticking two fingers up at the EU it's all fair and proper, when Scotland does it to them it's an outrage. I'd fire the lot of them into the fucking sun at this point.

Unless you're in cahoots with the betting agent, apparently. I'm not saying this is a sensible move other than for them to be as ballsy as they have, I would imagine they're making a killing somehow. Maybe loads of Phillipine gamblers bet they would stay up and the total value of transactions makes this one bet going the other way safe for the betting agency and a reward for the owners?

Ashley will be kicking himself that he didn't think of this.

I read it more as they've put a bet on themselves to get relegated (a bet with their shirt sponsor no less) and are trying to ensure it happens.

The owner of Wigan, a Hong Kong based poker player/gambler is actively trying to get them relegated in order to clean up on a bet - and so has placed them into administration to ensure they get a 12 point penalty and therefore relegation (he bet they would go down). It's staggering.

They're going to announce the heat death of the universe before this fucking takeover.

So he's actually the follow up to Boris Johnson then, not Cummings.

What that post really indicates tbh is that they don't care how shite they are, whatsoever, as long as we're vaguely in there with them. They'd be happy being the joint worst team in all of professional football as long as we were the other one. All this "Sonny knows his place, Sonny may be a fucking retard, but at least he knows to doff his cap to the big kids". Servile fucks. In my entire time talking to Newcastle fans about football, not once has one of them ever said to me "I don't mind how shite we are as long as the mackems aren't doing better". I know we all know this but it amazes me that they can't see it for the life of them.

What the gibbering fuck is wrong with whoever wrote that.

https://www.readytogo.net/smb/threads/sunderland-will-oppose-a-flat-salary-cap.1522210/ A flat salary cap would be fairly terminal for Sunderland, right? As in, it would effectively mean they can only get promoted through proper management and not just spending past everyone else. The whole "big club" factor is muted considerably. They're a shite club in general, and they absolutely deserve everything they get, but they are also monumentally unlucky It's like the universe wants them to burn.

He's from County Durham or something right? Maybe he fancies himself as the second Cumming.

I do not understand the right wing internet community - who the fuck is Darren Grimes, and why would anyone listen to a word he says? He appears to be 15 years old, and mentally about 5 years younger. He has no insights, no honesty, just nothing. Why is he a "thing" in the internet right? As for Starkey, he's always been a belligerent old fuck but at least his age is some excuse.

From the Guardian's MBM: I’m so pleased for Steve Bruce, who was the subject of some disgraceful ridicule earlier in the season. First he stabilised Newcastle defensively; now he has got them playing some lovely attacking football.

Chinese don't do dual nationality so not unless you renounce your British citizenship I fear..! Having said that, we already enjoy visa free access to HK (if memory serves).

I was insufficiently cynical about a lad named Brian who asked us to do a survey on brown rats. Hope that clears it up.

You clearly don't know many Chinese women

Those people don't qualify though, right? Only people born before 1997 qualify for this, so the young people on the streets don't make the cut sadly (well, up to 24 years old). Let's hope they don't come over primed and "grateful" to the Tories though.

Absolutely. But so is freedom of movement across Europe, is all I mean. I agree with them on this but I think it makes them rank hypocrites for all this immigration bullshit.

In fairness to the Brexiteers, from a hypocrisy standpoint, I'm seething about it too.

Did I miss some casual racism from Noelle? There's hardly anything that gets removed on here ffs

Nah, Brian didn't appreciate it last time.

The guy was clear and to the point which overwhelmed my short attention span, so I filled it in Good luck with your research. This one is more like 3 mins for anyone thinking of filling it in.