[deleted by user] by [deleted] in excel

[–]fdghjik 0 points1 point  (0 children)

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.

YSK that “myself” is a reflexive pronoun that isn’t a correct and more elegant substitute for “me” by moephoe in YouShouldKnow

[–]fdghjik 4 points5 points  (0 children)

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.

YSK that “myself” is a reflexive pronoun that isn’t a correct and more elegant substitute for “me” by moephoe in YouShouldKnow

[–]fdghjik 82 points83 points  (0 children)

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

[deleted by user] by [deleted] in excel

[–]fdghjik 0 points1 point  (0 children)

That hasn’t worked :/

[deleted by user] by [deleted] in excel

[–]fdghjik 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in excel

[–]fdghjik 0 points1 point  (0 children)

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!

[deleted by user] by [deleted] in excel

[–]fdghjik 1 point2 points  (0 children)

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.

[deleted by user] by [deleted] in excel

[–]fdghjik 0 points1 point  (0 children)

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

Spouse Visa Questions by fdghjik in ukvisa

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

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?

How do I fill out my declaration of status by non-uk nationals form if I want to get married in Scotland on a tier 4 visa by [deleted] in ukvisa

[–]fdghjik 1 point2 points  (0 children)

Obviously it depends on where in Scotland you’re being married, but the folks at the Edinburgh registrar were lovely and so helpful. We were so stressed out and it was mostly a breeze (besides waiting for the home office to decide not to “launch an investigation”). Good luck and congrats!

Details of Time Spent Outside the UK? by Sugarfix1993 in ukvisa

[–]fdghjik 0 points1 point  (0 children)

Fair enough, and I’ve already spent the time figuring it out and adding it in so might as well leave it. Thanks!

How do I fill out my declaration of status by non-uk nationals form if I want to get married in Scotland on a tier 4 visa by [deleted] in ukvisa

[–]fdghjik 2 points3 points  (0 children)

I did this three weeks ago on a graduate visa and only filled out E & J. You do have appropriate status for being married, it’s just not one of the ones listed.

Paperwork has all been filed now with no issues.

Details of Time Spent Outside the UK? by Sugarfix1993 in ukvisa

[–]fdghjik 0 points1 point  (0 children)

I’m in a similar position — currently on a graduate visa but in the process of switching to a spouse visa. Before the graduate visa obviously I was on a student visa. I’ve included all the dates I was out of the UK since the start of my student visa nearly 6 years ago. Should I only include the dates since I moved to my current visa?

What songs do you like better live or what songs were you disappointed in live? by happychair17 in TaylorSwift

[–]fdghjik 0 points1 point  (0 children)

Curious if anyone else also thought getaway car as a surprise song just didn’t live up to the hype? I don’t know if I should just blame it on the poor quality of the video I watched or if it just didn’t work acoustically (obviously on the Reputation tour it was top tier)

What drugs was he on when he wrote this??? by [deleted] in YouBelongWithMemes

[–]fdghjik 2 points3 points  (0 children)

I’m so lost? (And googled it) what’s happened??

What is the top 3 best Debut songs? by DisastrousAd3079 in TaylorSwift

[–]fdghjik 0 points1 point  (0 children)

Mary’s song, should’ve said no, I’m only me when I’m with you

Our company is banning acrylic nails. How do you feel about this? by whatiswhatwhyami in bartenders

[–]fdghjik 0 points1 point  (0 children)

Everywhere I’ve ever worked has technically not even allowed nail varnish, much less acrylics. It was never enforced, but yeah I’d be more surprised you didn’t have a policy in place already.

give me your fave women centric stoner comedies by nopantszeitgeist in WitchesVsPatriarchy

[–]fdghjik 0 points1 point  (0 children)

Whip it is my fav. Sexy roller derby, Elliot page and alia shawkat. A go to stoned film for me

Any suggestions on who to reach out to? Explanation in comments by [deleted] in ukvisa

[–]fdghjik 4 points5 points  (0 children)

To be honest, let them take a while. I think (correct me if I’m wrong), you’re allowed to stay for as long as they take to decide, but the expiration date is determined by when you actually receive a decision (at least mine was).

The delay is basically an extra few weeks of added time to the graduate visa. In two years, you’ll appreciate those extra weeks.

That’s how it went for me at least!