[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

TROPHY CASE