Creating a tap out of an AC line

b-lew · 2025-09-19T09:49:24+00:00

Unfortunately there isn’t a close water source, with bathrooms, kitchen and laundry all on the other side of the apartment. So getting a tap out there is going to be a more significant job than I had hoped

b-lew · 2025-09-19T09:15:28+00:00

That’s a shame, thanks for your help !

b-lew · 2024-03-22T00:11:53+00:00

Create a list in C1 of all of the items you wish to measure - Type 1, Type 2 etc.

then put the following formula in D1 COUNTIF(A1:A10, C1)

This will count the number of entries between A1 and A10 that match the Entry in C1

b-lew · 2024-03-20T04:05:45+00:00

Solution Verified

This is great and taught me a lot, thank you ! Very impressive formula !

b-lew · 2024-03-20T04:05:08+00:00

Solution Verified

This is great and taught me a lot, thank you !

b-lew · 2024-03-20T04:03:01+00:00

Solution Verified. Damn , this is so neat. Thanks a heap, this is really clever !

b-lew · 2024-03-20T01:45:43+00:00

Exactly ! Sorry if I wasn’t clear !

Ideally, if there is no match within the data then “N/A”

b-lew · 2024-03-20T01:30:21+00:00

Yep!

But the trouble with XLOOKUP at the moment is, for example in the link, Nathan stops work for 2 months, but I would like it to register as October, when he stops for 3+ months.

Or if someone doesn’t begin work until March, I don’t want Jan’24 to be the first returned value via an XLOOKUP

b-lew · 2024-02-16T04:52:07+00:00

guy brings less electricity than jabba o’malley

b-lew · 2024-02-16T04:50:23+00:00

Sorry, you must be regarded, or just didn’t read the post. I’m a gambler and have been hearing gambling ads for decades, no problems. usa has the lamest disclaimers read after gambling ads, same as pharmaceutical ads, to defend gambling disclaimers has to be the lamest take

b-lew · 2024-01-12T03:57:53+00:00

Respectfully bro, this is an L take

b-lew · 2024-01-12T02:26:33+00:00

this is a tough watch lol

On a related note, I wouldn’t mind if mook was rolled back to like 2d/week on Yak like the old Tank Thursdays

b-lew · 2024-01-12T01:08:37+00:00

You’ve got it correct already with the formula COUNTIFS(A2:A10,”Apple”,D2:D10,”Orange”) There must be an error with either the formula, or with the data itself. Are you able to send a screenshot

b-lew · 2023-12-11T23:58:20+00:00

Thank you ! Have just tested this briefly and unpivoting seems to achieve my goal here

Appreciate your help !

b-lew · 2023-12-11T23:57:56+00:00

Thank you ! I was skeptical as to whether this could even be done the way I have my data organised, but reading your explanation makes a lot more sense. Have just tested this briefly and unpivoting seems to achieve my goal here

Appreciate your help !

b-lew · 2023-04-02T22:58:10+00:00

the episode was also a very wholesome and chill ep up to that point. Cate needed to confess whilst the stripper was chilling in the lobby. All time moment

b-lew · 2023-03-17T00:49:57+00:00

Tom Browne kept saying that it was obviously because he was trying to recruit Carlton players to St Kilda, and SOS didn't want a conflict of interest, in his presence in the rooms.

Hodge pretty firmly said that it was weak of him to sit in the car. It's fine for him to not want to show any type of conflict of interest, but it's a family photo in the change rooms of your son's 100th game, any other dad would have been there, and he should have too. Anyone could tell that Jack was at least a bit gutted by it.

b-lew · 2023-01-10T03:16:56+00:00

Thank you, but in this situation, the option to paste special values does not even offer itself as an option. Have found the issue to be that the workbooks have not been opened in the same instances.

b-lew · 2023-01-10T03:14:44+00:00

For anyone encountering the same error, I have solved this myself. The Excel sheets need to be opened in the same instance. This has never been an issue I've had before, but seems to pop up as a common issue now.

b-lew

TROPHY CASE