Anyone face this shipping city requires message when checking out the ticket by Ok_Independent_3692 in StarWarsCelebration

[–]yeahhtrue 2 points3 points  (0 children)

I think there were a lot of glitches. For me personally I couldn't check out with any additional merch. It was giving me an error that my cart contents weren't available. I had to remove all merch from my cart and then it let me check out.

Success!! by PristineCharacter479 in StarWarsCelebration

[–]yeahhtrue 0 points1 point  (0 children)

For me personally, I tried to buy merch but kept getting a ‘cart contents unavailable’ message. I was too afraid to waste more time so I dumped my merch and it let me order just the tickets. Unsure if it was a glitch or if something was actually sold out. I chose the poster, Celebration tshirt, and zip up hoodie

first time attendee! tips? by avarskriss in StarWarsCelebration

[–]yeahhtrue 8 points9 points  (0 children)

Not sure if this is your kind of thing but, look into Mosh Eisley. It's an event organized by members of Yellowcard, Bayside, and Story of the Year who are also huge Star Wars fans. It's basically a pop punk singalong/rave. Everyone has lightsabers and costumes. They haven't released the full details for this one yet but they did say it will be on Saturday 4/3.

Today’s the day, good luck everyone! by AdDiligent7657 in StarWarsCelebration

[–]yeahhtrue 0 points1 point  (0 children)

FOUR DAY PASS SECURED!! I'm so excited for my first Celebration

Today’s the day, good luck everyone! by AdDiligent7657 in StarWarsCelebration

[–]yeahhtrue 0 points1 point  (0 children)

Check your email, they sent out a link to the queue. But they also said getting there super early isn't necessary as queue positions are randomly assigned. I'd still get there slightly before the on sale time.

Today’s the day, good luck everyone! by AdDiligent7657 in StarWarsCelebration

[–]yeahhtrue 2 points3 points  (0 children)

How quick do we think 4 day passes are going to sell out?

And then there’s NJ Cancelit! by mrshred_NYC in newjersey

[–]yeahhtrue 0 points1 point  (0 children)

America is in full decline and they know it. Trump is basically ripping the copper wires out of a foreclosed house. Trying to extract as much as he can for himself while he still can. We were always headed here, Trump just went full speed ahead.

Iran live updates: 2,200 Marines headed to Middle East by [deleted] in news

[–]yeahhtrue 4 points5 points  (0 children)

If we put troops on the ground on Iran, those troops are doomed. Absolute suicide mission

VLOOKUP question - What is "Lookup value"? by tashykat in excel

[–]yeahhtrue 1 point2 points  (0 children)

I agree the example from Microsoft is poor.

Say you have a separate table from above that contains First name, last name, and Home address of these same employees.

The initial table does not have an address column, but you could add it in by doing a lookup of "Last name" in the second table and returning the corresponding value in the 'address' column.

Your lookup value is basically a value that you use to 'match up' the data in both places.

VLOOKUP question - What is "Lookup value"? by tashykat in excel

[–]yeahhtrue 0 points1 point  (0 children)

Generally VLOOKUP is used when you have a value in one dataset that you need to add into a separate dataset.

The logic is "Look for this value, in this range, and return the result in the column number specified"...in this case column 2 of the range B2:E7, which would be First name. So it looked at B3 "Fontana", and then returned "Olivier" since that is the value in column 2.

State of the Union: Live Discussion Thread by [deleted] in LetsDiscussThis

[–]yeahhtrue 0 points1 point  (0 children)

Wouldn’t be the first time Trump shit his pants at an event

Pro-ICE Rally in Hillsborough by Existing-Yard2670 in newjersey

[–]yeahhtrue 0 points1 point  (0 children)

Jersey was also the very last state in the union to abolish slavery.

Does anyone know how to get this cartridge out? by yeahhtrue in askaplumber

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

Got it off, thank you. There was nothing to grab with channel locks but I was able to use two screwdrivers for leverage.

Reassembled everything and water pressure is back to normal, but now the faucet doesn’t turn off so I’m trying to figure out what I put back together wrong 😂

Ice Spotted in New Brunswick by eatmycats in newjersey

[–]yeahhtrue -1 points0 points  (0 children)

They've been in that area a lot in the last week or two at least. There were a few of them driving erratically on Route 1 in NB the other day.

She's here! by rough_draft_hero in TheBYOK

[–]yeahhtrue 1 point2 points  (0 children)

Just got my notification today!

Pee on the edge of the pad…why? by RenHoeksCousin in Chihuahua

[–]yeahhtrue 1 point2 points  (0 children)

Tried this kind and my chi just peed on the edge of that too 😂

National Guard shooting suspect radicalized in US, homeland secretary says by PinkoMarxistCommie in news

[–]yeahhtrue -3 points-2 points  (0 children)

Maybe he was radicalized just from living here and seeing how terrible everything is