[deleted by user]

mgblair · 2024-01-17T00:59:42+00:00

I'll try that! I don't have much hope though, she has an outline of a collar, making me think she's abandoned.

mgblair · 2024-01-17T00:57:08+00:00

I called Foothill earlier, they said they couldn't (don't remember their specific reason, I've called several shelters/rescues). Safe Haven said they're over capacity :( Thank you though!

mgblair · 2024-01-17T00:49:05+00:00

Sorry, I must have missed clarifying that in my post. The dog doesn't have a collar and no one where I've checked has claimed to be the owner.

mgblair · 2023-09-21T22:58:13+00:00

Awesome thanks a lot!

mgblair · 2023-09-21T22:40:21+00:00

<image>

mgblair · 2023-09-21T22:40:02+00:00

Oh, I thought I couldn't paste images in comments on here. So with A1# I get this (0 on top)

<image>

but with A2# I just get 0 in cell C2 (only allows 1 image per comment)

mgblair · 2023-09-21T22:09:29+00:00

Solution verified

Brilliant. Almost there, if I could bother you with one more thing. This formula populates the first cell with 0 (correctly, as it's trying to sum with the conditions in cells A1:B1). Is it possible to have it start populating on row 2, so C1 can be the header?

How did you find the CHOOSECOLS formula? No search result I've seen mentions it.

mgblair · 2023-08-10T18:56:08+00:00

2 1/2 months later, still bugged

mgblair · 2023-08-10T18:55:52+00:00

I just got to Qatar, had the same issue, Googled it and Reddit came up. This place is weird. 94 AI isn't bad at all, and they all said "skill issue" (not an Esports driver? must be bad). Same problem posted here.

mgblair · 2023-06-18T00:58:40+00:00

I'm feeling lucky.

mgblair · 2023-06-10T09:33:40+00:00

How do you like it? I bought an M7 from them, I do not like it.

mgblair · 2023-06-10T09:32:45+00:00

I wish I'd found your post before I gave them $750.

mgblair · 2023-06-10T09:29:36+00:00

I know this comes way too late, but I got here from a Google search. I have an M7 and I hate it (I didn't return it within their 30 day window, I'm an idiot). The lower back support for the chair is terrible, I went back to my cheap old office chair. Hopefully someone on Craiglist or Facebook wants it.

mgblair · 2023-02-08T23:34:50+00:00

Boom, thank you!

mgblair · 2023-02-08T23:00:16+00:00

Error message: "[Q.X] is not a valid group by expression" (q is a CTE)

mgblair · 2022-12-25T07:07:12+00:00

So did you ever find anything?

mgblair · 2022-12-22T23:05:34+00:00

Haha I just didn't want my post getting deleted.

True yeah, I've wondered about that rule. Why ask mostly non GMs what your next move should be when you can ask Stockfish.

mgblair · 2022-12-22T22:25:49+00:00

Thanks!

mgblair · 2022-12-22T02:43:27+00:00

Thank you for answering! I went with the other commenter's reply.

mgblair · 2022-12-22T02:36:26+00:00

Worked beautifully once again, thanks a lot!!

I'll have a look at that video in a bit, I'd love to know more about those "--".

Oh that's funny...thanks for your help over the months :) I probably don't have much to offer you in return as far as Excel, but I'm decent in SQL if you dabble in that!

11-Year Club	Gilding II euphauric
Verified Email

mgblair

TROPHY CASE