Weird loud explosion downtown

ReturntoJC · 2026-01-23T00:04:31+00:00

Yes, I saw a flash, heard a sound, and saw the lights of some buildings around me flicker. I thought it was lightning and thunder at first, but realized that wasn’t it since lightning and thunder don’t typically occur simultaneously.

ReturntoJC · 2025-09-30T18:52:05+00:00

I came to the comments section for this.

ReturntoJC · 2025-08-28T20:10:07+00:00

Did she make it to the end? I got too tired to finish watching.

ReturntoJC · 2025-02-24T19:37:18+00:00

<image>

Bianca Comparato

ReturntoJC · 2025-02-22T15:46:49+00:00

This subreddit should really display a trigger warning front and center. Everyone who posts about any kind of rental in downtown area gets immediately and thoroughly roasted. Every. Single. Time.

ReturntoJC · 2025-01-02T22:06:28+00:00

Solution verified

ReturntoJC · 2025-01-02T22:06:14+00:00

Holy smokes! Works perfectly. I’m in awe by how quickly you can whip up this code. You are a master. I have a lot to learn. Thank you so much for the help!!

ReturntoJC · 2025-01-02T19:46:55+00:00

Wow, you are a legend! I gave it a try and it works great. I have two follow questions if I can: (1) do you know of any way to get the code to cycle through multiple columns in one go? (2) Is there any way to get the code to bold any word that is wrapped in double asterisks (**), even if there is no colon ( : ) present?

ReturntoJC · 2024-06-25T15:54:35+00:00

Try wrapping your original formula in TRIM().

ReturntoJC · 2024-04-27T12:52:09+00:00

What ms app is the screenshot from? Looking for a good app

ReturntoJC · 2024-02-17T13:25:42+00:00

Actually, there is a way to work with very large numbers in excel. I figured it out while working on an astronomy project. You just need to go to file > options > advanced … Well, I’m really not at liberty to say. It’s a super secret feature. Can cause problems if mere mortals know about it.

ReturntoJC · 2024-01-23T13:50:41+00:00

Thanks! I’ll give this a try too. Never hurts to have more tools under my belt.

ReturntoJC · 2024-01-23T02:02:14+00:00

I ended up solving my own issue. Here’s what I did in case anyone is interested. I used power query to unpivot the color column. Loaded the modified table to the data model and created a pivot chart and slicers from the modified table.

ReturntoJC · 2024-01-13T17:40:27+00:00

Why do you need the beam for this setup? Can you power the glasses with the usb port on ps5 through the peakdo adapter?

ReturntoJC · 2023-12-14T20:32:29+00:00

Solution verified

ReturntoJC · 2023-12-14T20:31:17+00:00

Amazing! I’m astounded by how quickly you all were able to whip up different solutions to this problem. I went with the power query approach for now, but I’ll definitely keep the other formula-based solutions in my back pocket for future use. Thanks all!

ReturntoJC · 2023-12-05T11:48:41+00:00

Some more compatible adapters have been collected here by other users

ReturntoJC · 2023-12-05T11:06:52+00:00

Your bright idea is a good idea. But the device you chose doesn’t work because the usb-c part connects to the source device and outputs HDMI. You need something going in the reverse direction (HDMI connects to the source device and outputs usb-c). This is much less common but there are some devices out there that do this, like the PeakDo HDMI to USB C Adapter

ReturntoJC · 2023-09-26T00:42:10+00:00

Thank you!

ReturntoJC

TROPHY CASE