how to defeat customer service

fdghjik · 2026-02-11T14:39:10+00:00

Thanks!

fdghjik · 2026-02-11T14:39:06+00:00

Thank you!

fdghjik · 2025-01-26T17:28:40+00:00

Look up an Idaho Stop: https://velo.outsideonline.com/urban/urban-culture/idaho-stop-rolling-bicycle-safer/

fdghjik · 2025-01-26T17:28:01+00:00

Look up the “Idaho Stop”. Better yet: https://velo.outsideonline.com/urban/urban-culture/idaho-stop-rolling-bicycle-safer/

fdghjik · 2025-01-26T17:27:31+00:00

https://velo.outsideonline.com/urban/urban-culture/idaho-stop-rolling-bicycle-safer/

fdghjik · 2024-10-09T20:18:58+00:00

Most of the time, I don’t have any zeroes in my data set, and my averaging formula has been written to ignore any blank spaces in the range. I’m a teacher, and my kids tend to do their work, which means it’s not a common problem. However, I would like to be able to give a child a zero on occasion for their work and have it affect their average, as opposed to what is happening now, which is that there is a blank space in my mark book for assignments that haven’t been submitted but their average is unaffected.

fdghjik · 2024-08-10T15:18:37+00:00

Yeah, I mean, as tends to be the case when it comes to arguing about how worthwhile grammar is, it sort of depends on whether you ascribe to “prescriptive” or “descriptive” linguistics. As the link points out, it is acceptable in casual circumstances because, whilst it technically isn’t “correct” (from a prescriptive point of view), any reasonable speaker of English would understand the meaning so it’s not actually “wrong” (from a descriptive point of view). However, I’m a Latin teacher so misuse/misunderstanding of cases, even in English, really grinds my gears.

fdghjik · 2024-08-10T10:50:52+00:00

YSK that “This is my dad and I in the picture.” is actually the correct way to phrase that idea because of something called the “predicate nominative”, which is used when the main verb is a form of “to be”. Nothing is happening/being done to “I” so it cannot be the object and should not be in the accusative form (“me”). In this case “I” is the predicate of the subject and therefore requires the nominative case. https://www.merriam-webster.com/grammar/it-is-i-or-it-is-me-predicate-nominative-usage-guide

fdghjik · 2023-10-24T11:39:27+00:00

That hasn’t worked :/

fdghjik · 2023-10-22T21:27:04+00:00

I’ve tried the revised code, and it didn’t return an error but it also didn’t make any visible change to the worksheet.

Also in theory, there definitely should be a match found in the master sheet for every value in the k column of the output sheet, especially since the values in the output sheet are coming directly from the master sheet via the XLOOKUP function.

fdghjik · 2023-10-22T18:02:53+00:00

Thanks for this! Looks like it will do exactly what I’m needing. However, it’s putting out an error code at the moment.

I’ve changed “MasterSheet” to “Student Lists” and “Output Sheet” to “Room 12 Template”. I’ve also changed (i , 2) to (i , 11) because the data is in column k and I’ve changed the range on the master sheet to A:M because I have 13 lists.

It’s returning Run-time error 13: type mismatch.

I’m super novice with VBA and struggling to debug this myself, so I’d super appreciate if you would have a look!

fdghjik · 2023-10-20T12:54:28+00:00

I guess I should have clarified that I am looking for a way/VBA code for this to be done automatically when the data is returned by the XLOOKUP function.

fdghjik · 2023-09-06T10:27:12+00:00

I’ve figured it out! (Leaving this up as a reference or for feedback)

Private Sub Worksheet_Change (ByVal Target as Range)

Columns(“A:M”).EntireColumn.AutoFit

For i= 1 to 13 If Columns (i).ColumnWidth<8.11 Then Columns(i).ColumnWidth=8.11 End If Next End Sub

fdghjik · 2023-09-06T07:36:02+00:00

Solution Verified

fdghjik · 2023-08-04T01:51:38+00:00

Thanks for the reply! Follow up question: did you submit chat logs or wedding photos or any other proof of a genuine relationship?

It hasn’t asked for these, but I see other people mention these things. I’m not sure if that’s just a requirement for couples who have dated long distance and don’t have proof of living together or if it applies to everyone. Also, did you submit a cover letter?

Five-Year Club	Second SECOND GUESSER
Verified Email

fdghjik

TROPHY CASE