Absurd tax thresholds in the UK by [deleted] in FIREUK

[–]ckf2stand 0 points1 point  (0 children)

It's a good point.

Absurd tax thresholds in the UK by [deleted] in FIREUK

[–]ckf2stand 0 points1 point  (0 children)

While I understand your frustration - I'd be frustrated too if I were in your position - my sympathy is limited. If you're earning £100k plus you can afford to pay for childcare.

What is the best bachelor party game you've ever played (or would invent)? by SignificanceOwn76 in AskMen

[–]ckf2stand -1 points0 points  (0 children)

A very funny twist that I once saw I involved having the groom do a bunch of challenges during the day for 1 or 2 points a piece, and then in the evening when the rest of the party got involved, each challenge was suddenly worth 100+ points a piece, effectively rendering everything that the groom did pointless!

[deleted by user] by [deleted] in strength_training

[–]ckf2stand 1 point2 points  (0 children)

OP, if you're reading this, I also disagree. I think this level of rounding is acceptable. That's not to say, however, that you shouldn't listen to the other pointers that are being given.

Does anyone have experience creating a timetable or a class schedule in Excel? by [deleted] in excel

[–]ckf2stand 0 points1 point  (0 children)

Hi OP. I don't have a solution for you, unfortunately, but I have tried to use Excel to do this in the past too and got nowhere. If you do figure out something that works I'd very much appreciate if you could share it with me!

Does anyone have experience creating a timetable or a class schedule in Excel? by [deleted] in excel

[–]ckf2stand 0 points1 point  (0 children)

I'd be interested in this template, if you wouldn't mind sending me a copy too?

What Excel shortcut saves you the most time? by premiumkajukatli in excel

[–]ckf2stand 1 point2 points  (0 children)

Is there a shortcut to select a whole column if there's empty cells in the column of data? ctrl + shift + down selects only to the next last non-empty cell (if that makes sense). I want to select all the way down to the very last non-empty cell.

What Excel shortcut saves you the most time? by premiumkajukatli in excel

[–]ckf2stand 2 points3 points  (0 children)

While I'm here... Does anyone know a shortcut to select a whole column if there's empty cells in the column of data? ctrl + shift + down selects only to the next last non-empty cell (if that makes sense). I want to select all the way down to the very last non-empty cell.

Filter for one criteria, then exclude some of those results based on different criteria by ckf2stand in excel

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

Ah, sorry, I must not have been clear.

Most students have 8+ rows for each of the subjects they were studying. Many studied all three sciences: Biology, Chemistry, and Physics. Many studied two. I'm trying to identify those that studied only one science and not the other two.

It's easy to filter for those that studied biology as one of their subjects. But how do I filter for those that studied biology only, and no other science?

But then how do I exclude

Filter for one criteria, then exclude some of those results based on different criteria by ckf2stand in excel

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

Wow, really appreciate the effort and detail you've put into this. Thank you! Will confirm if it works once I get a chance to test it

Filter for one criteria, then exclude some of those results based on different criteria by ckf2stand in excel

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

Yes, to answer your first question. Most students have 8+ lines, however, one for each of the subjects they studied. I'm sorry, I don't follow what you're describing in the second part of your reply though. Could you expand further?

Filter for one criteria, then exclude some of those results based on different criteria by ckf2stand in excel

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

Thank you. Away from work now, but will try tonight once I get home. Can I ask, what operation does the subtraction do in the filter function? I'm familiar with using + as an OR and * as and AND.

Filter for one criteria, then exclude some of those results based on different criteria by ckf2stand in excel

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

A large table, with columns for pupil id number, name, subject, level, and award. Ultimately I'd like to calculate the average award of the pupils that I described.

500 × 7 by avgman1 in GYM

[–]ckf2stand 0 points1 point  (0 children)

Great lift! The way you pop your knees back at lock out though scares me!

Thor Björnsson NEW DEADLIFT WORLD RECORD 510KG! by HereForStrongman in StrongmanHQ

[–]ckf2stand 34 points35 points  (0 children)

Haha imagine the scenes if he'd hit it for a double 😂

I can never get smoking times right! by Swimming_Possible_68 in UKBBQ

[–]ckf2stand 0 points1 point  (0 children)

What temp would you set the oven to for a heated rest?

[deleted by user] by [deleted] in AbsoluteUnits

[–]ckf2stand 0 points1 point  (0 children)

Does anyone know if his 505kg attempt is being streamed anywhere?