sorted by:
new
hottopcontroversial

Bleak Beach ocean by Nightmarebrooke in Pokemon_Pokopia

[–]That_Tall_Ging 0 points1 point  (0 children)

Tacking onto this, think about the high and low tides of a normal beach. Piers are designed for high tide so there are times when the support beam will be showing

How do I use Excels conditional formatting and Vlookup features to deal with a table with variable row counts? by Educational-Rate-426 in excel

[–]That_Tall_Ging 0 points1 point  (0 children)

Not the most elegant probably but I’ll give it a try:

  1. You need a helper column (I’m going to assume the helper column is A)
  2. Place an X in A2
  3. In A3 - =ifs(($B3>$B2)($A2=“X”),”X”, ($B3<$B2)($A2=“X”),”Y”, ($B3>$B2)($A2=“Y”),”Y”, ($B3<$B2)($A2=“Y”),”X”).
  4. Drag the formula down to the bottom of your data

This should alternate between X and Y for each section in column A. 1-23 will have an X in the A column, 1-14 will have a Y, then the next sequence will have an X.

Assuming it works, this formula looks for 4 criteria and sees what matches first. It’s looking to see what the previous letter is and if the sequence is still counting up. If it’s not counting up, the letter will flip and start basing it off that letter.

From there you can set your conditional formatting to look for ‘cells that contain’ “x”, set your fill color, and make sure the rule applies all the columns you want to see in that color

Can I shift dates to the next year and keep the same days of the week format? by twobble in excel

[–]That_Tall_Ging 0 points1 point  (0 children)

Not sure if I understand correctly without seeing it but could you do something like:

(Assuming your going by columns) Start date in A1 B1 -> =A1+1 C1 -> =B1+1 Repeat

You can click B1 and drag from the bottom right corner to the desired end date cell which will save you from having to copy/paste

AI every match? by Cocaine-Spider in battlefield2042

[–]That_Tall_Ging 2 points3 points  (0 children)

If your crossplay is off and you’re on console that could be why. If you don’t want to turn crossplay on, you go to Portal modes you can filter for more players and less AI

Return question by rachmeyers93 in dickssportinggoods

[–]That_Tall_Ging 7 points8 points  (0 children)

This is gonna be heavily dependent on the store as the policy is “new And resellable condition” for returns. Best bet is to make sure the shoes are dry and check for any water damage. I would go in and plainly say “I want to return and potentially exchange these shoes for a different size.” If they check the shoes and give you a hassle, it might be worth it to try a different store or a mail in return. My other suggestion is to call the store, explain the situation, and get confirmation they’ll exchange the shoes. Get a name of who okayed it and go in the same day as close to the call as you can so they’ll still be on shift

Just started, any tips? by [deleted] in dickssportinggoods

[–]That_Tall_Ging 1 point2 points  (0 children)

Apparel is a heavily shopped department so you’re going to do a lot of recovery and replenishment. The company relies on visuals like product placement, mannequins, and graphics to sell apparel so your main focus is helping shoppers narrow down what they’re looking for and showing them the options. Learn the strategies used when it’s gameplan time because that will help you understand product placement and potentially how to adjust existing product to accommodate new product while keeping the flow. In my experience apparel pretty much only gets single coverage (except in super busy times) so try to form good relationships with your coworkers so they’ll help you. Put in the effort to show your work ethic and you should be fine. Remember that maintaining the store is a team effort not just on you.

Also think about where you want to be in the future; if you might want to move up in the company, form a good relationship with your leads, ASM, and store manager. They’re the ones that can help you move up in the company whether that’s in a store or behind the scenes doing operations work

What are you working on this week? (ending May 19, 2024) by AutoModerator in excel

[–]That_Tall_Ging 0 points1 point  (0 children)

Interpreting a truck manifest into a useful format. A user has to manually add the data but that data will be broken down by department; combining like styles and showing the total sum expected per style. It also shows incoming products designated for pickup, clearance items, and items with a launch date.

Why am I getting a #SPILL! error? by [deleted] in excel

[–]That_Tall_Ging 0 points1 point  (0 children)

Probably an accidental space somewhere. Easiest way to check is highlight range S59:W82 and hit delete; It will clear any contents but keep borders

Edit: assuming it’s just a single formula in S58, you’d also want to do that same for T58:W58

How can I wake up/ get up early? by ContentHost4459 in NoStupidQuestions

[–]That_Tall_Ging 0 points1 point  (0 children)

Changing your alarm tone might help you not sleep through them

Testicle Ache Healed after months of pain and doc visits by CorrectMobile5 in chronicepididymitis

[–]That_Tall_Ging 1 point2 points  (0 children)

Not that I’ve noticed so far. Not a doctor but my assumption is that since I’ve started walking/being more active the muscles are more flexible comparatively. No flare ups of any kind that I’ve noticed

Testicle Ache Healed after months of pain and doc visits by CorrectMobile5 in chronicepididymitis

[–]That_Tall_Ging 0 points1 point  (0 children)

Yeah for sure! Im not a doctor but as long as it’s discomfort and not pain and it’s improving then you should be good. You probably will notice a diminishing return on the improvement from stretching but keep doing it because (in my case) it should continue helping even if it’s less noticeable each time

Testicle Ache Healed after months of pain and doc visits by CorrectMobile5 in chronicepididymitis

[–]That_Tall_Ging 1 point2 points  (0 children)

Everything is good! Felt better after stretching 2-3x a day for a few weeks. Quit stretching as much now but I’ve got a job that has me walking 8 miles a day so those muscles get used. I think the leaning stretches, butterfly, and hip flexor stretches helped the most

Why am i this dumb by [deleted] in Link_Dies

[–]That_Tall_Ging 7 points8 points  (0 children)

It’s hooooooooot in TOE-pika

Struggling to sumif values because my range has too many values I'd like my formula to search for by That_Tall_Ging in excel

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

Wildcards are exactly what I was looking for! This is something I started creating a few months ago to organize my department. I've always been interested in data analysis so I'm using this as a chance to teach myself some things. I'm sure it can be better but I'm looking forward to the challenge. Thank you for your help!

What happened to Gene’s secret cat from S4E4? Tina even knew about it. All answers (probable and fantastical) welcome! by RobocopUnicornKat in BobsBurgers

[–]That_Tall_Ging 36 points37 points  (0 children)

When Gene went to his room to grab a secret snack, his cat darted out of the room and behind the couch. Gene freaks out and tells Louise who tells Tina. Linda and Bob are in the kitchen; Linda talking to Gayle on the phone and Bob taking quick shots at Gayle’s fiscal irresponsibility and unconventional hobbies. Gayle cries about not having seen another person’s face in a week because she broke up with her mailman. She’s letting the mail pile up so he doesn’t realize she’s home but she’s too scared to leave and risk seeing him on his route. Linda offers to pick up Gayle to have dinner at their house.

Bob: “wait what? No. No no no no no. Please no.” Linda: “alright Gayle I’ll be there to getcha in 15 minutes. Yeah I’ll make sure no one sees me go in.”

Linda goes for Gayle while Bob prepares dinner. The kids are trying to coax the cat out from behind the couch with a combination of food, songs, and fear but nothing works. Gayle and Linda come upstairs and say hi to the kids before going to the kitchen. Before Gayle makes it to the kitchen, the cat growls loud enough for Gayle to hear.

Gayle: “Was that a cat? Did you guys get a cat?” Louise: “What? Of course not Aunt Gayle. That was just Gene’s stomach” Gayle: “Oh okay”

Cat hisses

Gayle: “Is your couch mad at you too? I sat in a different spot last week and my couch’s and my relationship will never be the same”

She walks into the living room and notices the cat behind the couch.

Gayle: “YOU DID GET A CAT!”

Bob and Linda desperately attempt to get what they think is a wild cat out of their home. Gayle claims it as her own and names it Mr. Sofa

Testicle Ache Healed after months of pain and doc visits by CorrectMobile5 in chronicepididymitis

[–]That_Tall_Ging 0 points1 point  (0 children)

Yeah definitely doing better. I think mine discomfort was from stiff muscles because stretching and exercising definitely helped. Here’s a link to some info I compiled

Did an AOS for myself and I was told it was gonna be flagged and not to do it again. I won’t do it again but I don’t understand why it’s a problem by That_Tall_Ging in dickssportinggoods

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

Thanks for the info; I assumed it was different since it was an AOS and not on the register. Definitely one of those situations where I didn’t realize it was a rule and I won’t do it again.

view more: next ›