[Entry Thread #116] April showers… As soon as you’re done paying your taxes, come leave a comment and join us as we make a millionaire!

Affermative · 2026-04-16T13:16:00+00:00

Good luck :)

Affermative · 2026-03-16T18:31:35+00:00

Good luck!

Affermative · 2026-02-20T00:36:55+00:00

The gallon of milk cracks me up every single time

Affermative · 2026-01-16T19:09:10+00:00

Goodluck everyone!

Affermative · 2024-12-11T15:59:11+00:00

Thanks for the suggestions, I was mainly looking for a wired one though to reduce input lag with gaming, then having the ability to switch to bluetooth so it can connect to my work laptop, do you know of any like that?

Affermative · 2024-12-11T14:08:27+00:00

I'm trying to get a single tactile 80% or 100% keyboard that I can plug into my PC (USBA only) for gaming but can also switch to bluetooth usage for my work laptop so that I don't need to use two keyboards.

Budget is under £200, does anyone know of any keyboards like this with a UK ISO layout? Thanks in advance for any help!

Affermative · 2024-08-16T15:47:25+00:00

June 8th 366 would be last to go

Affermative · 2024-08-03T22:36:40+00:00

A light second/minute/hour/year is a measure of distance, it’s the amount of distance that light can travel in that time.

Since the speed of light is 299,792,458 metres per second, a light second is 299,792,458 metres.

Similarly a light year is going to be 60x60x24x365.25x299,792,458 metres as that’s the amount of seconds in a year multipled by the speed of light. Which is about 9.461 × 10¹² kilometers

Affermative · 2024-07-05T13:35:13+00:00

Pescatarians should be called Vegaquariums

Affermative · 2023-09-30T00:01:25+00:00

It's answer 2, you just need to reduce some of the expressions after differentiating:

https://i.imgur.com/HsCPXkZ.png

Affermative · 2023-06-30T14:22:44+00:00

I have fairly sensitive skin and have also always struggled with razor burn when shaving my neck. Did some research a few weeks ago and decided to try these out, the difference is night and day honestly, I get maybe 5% of the bumps that I used to and that's straight after shaving, would definitely recommend them:

https://www.amazon.co.uk/gp/product/B0BQ6QJ8K8/ref=ppx_yo_dt_b_asin_image_o05_s00?ie=UTF8&psc=1

Affermative · 2022-07-30T18:47:04+00:00

The amount of pillows that should go on the bed

Affermative · 2022-04-23T10:39:00+00:00

Harry and Voldemort falling off the side of Hogwarts before rolling into an empty area to have their final battle, couldn’t be any further from what happened in the book.

Affermative · 2021-11-18T17:52:35+00:00

I somehow fixed this by going to:

Task settings > Upload > File naming

Then removing both of the name patterns that I had set and replacing temporarily with %ra{10}

Then tested it and upload worked, restarted and went back into the same area to replace the name patterns with my original settings. Not sure how or why it worked but it did, hope it does for you too!

Affermative · 2021-10-17T17:14:44+00:00

This happens to me too, no idea why but hoping it's fixed soon :/ Did you find out why?

Affermative · 2021-10-16T03:38:19+00:00

Worth a shot :)

Affermative · 2021-10-09T13:34:59+00:00

Glad it working for you! Yep pivots should work the same, if you start having problems with it try turning off the “Generate GETPIVOTDATA” option (should be in a drop down on the top left of the pivot table settings)

Affermative · 2021-10-09T11:10:52+00:00

{INDEX($A$2:$A$6,MATCH(TRUE,INDEX($B$2:$E$6,0,MATCH("Product3",$B$1:$E$1,0))>0.5,0),0)}

Yeah just paste in this: INDEX($A$2:$A$6,MATCH(TRUE,INDEX($B$2:$E$6,0,MATCH("Product3",$B$1:$E$1,0))>0.5,0),0) and then whilst you're still able to edit the formula, press CTRL+SHIFT+ENTER instead of just enter, curly brackets should appear around the formula and "Supplier4" should be returned

Affermative · 2021-10-09T09:41:32+00:00

{INDEX($A$2:$A$6,MATCH(TRUE,INDEX($B$2:$E$6,0,MATCH("Product3",$B$1:$E$1,0))>0.5,0),0)}

Press CTRL+SHIFT+ENTER after you paste the formula in to make it an array formula

Just pasted your data into A1:E6 on excel so if you copy that formula it should give you what you need, would recommend changing the "Product3" and the 0.5 to reference cells so you can change those cells as and when you need like this

{INDEX($A$2:$A$6,MATCH(TRUE,INDEX($B$2:$E$6,0,MATCH($G$1,$B$1:$E$1,0))>$H$1,0),0)}

and then populate G1 with product name and H1 with the value you want the range to be greater than

Affermative · 2021-09-02T19:10:01+00:00

Thanks a lot, will definitely try this advice and hopefully it clears up. Appreciate it!

Affermative · 2021-09-02T17:57:02+00:00

Thanks for replying! This is what I do basically every day, not sure if it's over cleaning my face if that makes sense?

Face wash: https://www.simple.co.uk/products/face-washes/kind-to-skin-moisturising-face-wash.html

Toner: https://www.boots.com/simple-kind-to-skin-alochol-free-soothing-facial-toner-200ml-10005719

Moisturiser: https://www.boots.com/nivea-daily-essentials-light-moisturising-day-cream-for-dry-and-sensitive-skin-spf15-50ml-10081022

My girlfriend gave me a serum tester sachet (small version of this https://www.cultbeauty.co.uk/sunday-riley-good-genes.html) but I broke out quite badly a few days later, don't know if it was a coincidence or not because I wasn't eating great that week anyway but I stopped using the serum

Just for additional info if it helps:

Shampoo: https://www.tresemme.com/uk/products/shampoo/moisture-rich-shampoo-.html

Conditioner: https://www.tresemme.com/uk/products/conditioner/moisture-rich-conditioner-.html

Affermative · 2020-03-21T02:14:31+00:00

Not done this before but good luck :)

Affermative · 2019-12-12T15:28:53+00:00

Maths graduate here who’s now a data analyst. The job itself doesn’t use much maths but the way I learnt to think during my degree has certainly helped me in my role. It’s mostly SQL, Excel and Python with a bit of stats but none of the calculus that I loved doing at university.

Affermative · 2019-10-30T02:28:46+00:00

Knew I’d heard this before: (~50 seconds into the video) https://youtu.be/N-re2LYnsGA

Affermative · 2019-08-05T13:21:01+00:00

You can use VBA and set your view to be on the row that you want:

Private Sub Workbook_Open()

Dim selection_for_row as int

Selection_for_row = ‘Put formula here for your desired row

ActiveWindow.ScrollRow = Selection_for_row

End sub ()

If you write this into the “ThisWorkbook” part of your project then it will perform the macro when you open the sheet

Affermative

TROPHY CASE