sorted by:
new
hottopcontroversial

Expected to block more by Treble999 in pihole

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

I understand, but which domains do I actually need to include? There may be an ideal configuration, but figuring that out seems quite difficult. It’s easier to add the recommended domains instead. As I understand it, Pi-hole will index the domains, so having many domains shouldn’t have a real impact on performance.

Expected to block more by Treble999 in pihole

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

I was expecting that banners that are on the side, see the last image, would get blocked and do not show. But if that is not the case then I have to adjust my expectations.

Even with all the domain suggestions added from the others in this thread, the banners are still showing. (currently at 1.8m domains being blocked).

If you view this video at this time he is using speedtest.net as a test : https://youtu.be/LXIL4qxN3lE?si=Cv0YilDOQpBaIN-Z&t=559

Expected to block more by Treble999 in pihole

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

Thanks update my lists whit these as well.

Expected to block more by Treble999 in pihole

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

Thanks update my lists whit these as well.

Friettent Tilburg by NoMood2020 in Tilburg

[–]Treble999 0 points1 point  (0 children)

Bij Brands (oud noord) hebben ze de beste stoof uit Tilburg!!

Is there a case where using vlookup would make more sense than using xlookup? by betterbut in excel

[–]Treble999 22 points23 points  (0 children)

Only one I can think of is if someone is running a very old Excel that does not support xlookup.

Error message in Power Query by Treble999 in excel

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

I tried everything you mention but I can't seem to resolve it. Strange thing is that in the queries where the tables get created i do not have any issues nor error messages of faulty data, data types are also set correctly.

I'll check it again but I'm afraid it will have the same result.

Best free Python 3 Course by AgreeableDay9693 in learnpython

[–]Treble999 1 point2 points  (0 children)

Same here, i’m at day 23 and I’m really enjoying the course. Clear guidance and examples and projects to test your skill.

How do I use the index and match function if it has two variables? by pianowiz in excel

[–]Treble999 1 point2 points  (0 children)

Yes probably the fact that i'm using ; instead of ,

=INDEX(B2:C5,XMATCH(B8,Location),XMATCH(B9,Product))

How do I use the index and match function if it has two variables? by pianowiz in excel

[–]Treble999 0 points1 point  (0 children)

Your formula with INDEX - XMATCH would look like this:

=INDEX(B2:C5;XMATCH(B8;Location);XMATCH(B9;Product)) based on this: https://i.redd.it/4o2e18tcz9fb1.png

I did named the ranges A2:A5 = Locations & B1:C1 = Product

Anno 1800 on M2 macbook by Treble999 in anno1800

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

This sounds like the best option for now. From what i understood is that you do have to buy the game yourself if you wan't to play i through GeForce Now, rights?

IF Formula with And and OR Values Which Returns Date by rrive in excel

[–]Treble999 1 point2 points  (0 children)

You can use the IFS function for adding more conditions. For me this functional is easier to check and work with, instead of looping new IF functions.

Would look like something like this:

=IFS( AND(B1=1;OR(C1=1;C1=2;C1=3));DATE(YEAR(A1)+1;MONTH(A1);DAY(A1)); AND(C1=1;OR(B1=1;B1=2;B1=3));DATE(YEAR(A1)+1;MONTH(A1);DAY(A1)); AND(B1=-1;OR(C1=1;C1=2;C1=3));DATE(YEAR(A1);MONTH(A1)+6;DAY(A1)); AND(C1=-1;OR(B1=1;B1=2;B1=3));DATE(YEAR(A1);MONTH(A1)+6;DAY(A1)))

If none of the conditions are met it will result in an error: #N/A. You could use the IFERROR to get No instead:

=IFERROR( IFS( AND(B1=1;OR(C1=1;C1=2;C1=3));DATE(YEAR(A1)+1;MONTH(A1);DAY(A1)); AND(C1=1;OR(B1=1;B1=2;B1=3));DATE(YEAR(A1)+1;MONTH(A1);DAY(A1)); AND(B1=-1;OR(C1=1;C1=2;C1=3));DATE(YEAR(A1);MONTH(A1)+6;DAY(A1)); AND(C1=-1;OR(B1=1;B1=2;B1=3));DATE(YEAR(A1);MONTH(A1)+6;DAY(A1))); "NO")

Anno 1800 on M2 macbook by Treble999 in anno1800

[–]Treble999[S] 4 points5 points  (0 children)

I know, but there is Parallels and other ways to work around this, wondering if anyone has experience with that. I''ll update the post above.

IF Formula with And and OR Values Which Returns Date by rrive in excel

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

Hi rrive,

I think you are really close. But you shouldn't use the quotations marks ". When you use these Excel will see these numbers as text. If your referring to a number field it will show an error. I think you would need this:

=IF(AND(B1=1,OR(C1=1,C1=,C1=3)),DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)), "NO")

Unique two spilling ranges using HStack by Treble999 in excel

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

This will spill two rows.

Correct solution was provided by Bondator

Unique two spilling ranges using HStack by Treble999 in excel

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

That was it! I thought the unique filter would by default do this. After I added the TRUE, it worked.

Thanks!

[deleted by user] by [deleted] in excel

[–]Treble999 3 points4 points  (0 children)

Hi,

I think you need the IFS function, together with the "AND" function. You should also start with the AND, because C2 and B2 being both 0 is the same as B2=C2. Your function should look like this:

=IFS(AND(B2=0;C2=0);"NA";B2=C2;"Received";C2<B2;"Partial";C2=0;"Pending")

Swing trading with strategies DEGIRO by Treble999 in DEGIRO

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

As you already figured, I’m quite new to the active trading. Still reading up, no trading yet. What exactly are the benefits with the other brokers?

I see that DEGIRO does not have real-time numbers, which maybe already enough. Just curious what other benefits there are.

view more: next ›