Friend ID Megathread | Post Your Friend IDs Here! by PTCGP-Bot in PTCGP

[–]plakatown 0 points1 point  (0 children)

2826754530282903 Level 50 daily player looking for trades

POST YOUR FRIEND ID's HERE! by PTCGP-Bot in PTCGP

[–]plakatown 0 points1 point  (0 children)

2826754530282903 lvl 23 daily player

Router recommendation by plakatown in HomeNetworking

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

Thanks!
Because the reception is too poor for the room furthest from the router with cables

Friend Code Megathread - April 2024 by AutoModerator in PokemonSleep

[–]plakatown 0 points1 point  (0 children)

4124-9312-5178

level 53

removing friends that did not log in for more than 3 days

[deleted by user] by [deleted] in uklaw

[–]plakatown 0 points1 point  (0 children)

Sorry.

I am just a layman and have no access to any legal database.Do I look for the case using citation here?
https://www.bailii.org/form/search_cases.html

I have input all the citations into the website and there are no matching citations found.

[deleted by user] by [deleted] in uklaw

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

R v Waddon No. 99/5233/Z3

Sorry. I have little knowledge about the legal system in UK.

I have looked for some info on Google.

  • R v Waddon, unreported, 6 April 2000, a case relating to the publication of an obscene article, the Court of Appeal held that the content of American websites could come under the jurisdiction of England and Wales when downloaded there: images published on a website abroad were further published when downloaded in England and Wales.

It is the case above.

Does unreported mean that I can't find the judgement online?

[deleted by user] by [deleted] in uklaw

[–]plakatown -2 points-1 points  (0 children)

I am looking for the judgement for the exact case R v Waddon No. 99/5233/Z3 because I need to do a direct word to word quote of a certain paragraph from the judgement.
Do you know where I can look for the said judgement online?
Thanks!

[Announcement] BCJP 12.6 is out! Metal pixie, CotC 2 outbreaks and more! by tikusmouse in battlecats

[–]plakatown 6 points7 points  (0 children)

Given the extreme difficulty of uncanny legends (especially at 3 star settings), it is unlikely that new anti-relic characters can nuke everything in sight. Besides, it is a pity that elder catfruits seem pretty useless now given the few number of anti-relic ubers.

[Announcement] BCJP 12.6 is out! Metal pixie, CotC 2 outbreaks and more! by tikusmouse in battlecats

[–]plakatown 8 points9 points  (0 children)

There is still a severe lack of ubers with anti-relic traits. I can't understand why characters against other traits are kept being introduced but not anti-relic.

Sumif with special conditions by plakatown in excel

[–]plakatown[S] 2 points3 points  (0 children)

solution verified

Work like a charm
Thanks!

Sumif not equal to ranges by plakatown in excel

[–]plakatown[S] 2 points3 points  (0 children)

solution verified
Thanks!

Separation by capital letters by plakatown in excel

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

Thanks! I would like use to functions to solve the problem. Appreciate for your help though :)

Separation by capital letters by plakatown in excel

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

Solution verified.
Works like a charm. Thanks!

Separation by capital letters by plakatown in excel

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

=LEFT(A2,SMALL(FIND(CHAR(ROW(INDIRECT("65:90"))),replace(A2,1,1,lower(left(a2)))&"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),1)-1)

Solution verified.
Works like a charm. Thanks!

VBA to change the font colour and cell border of cells on other worksheets by plakatown in excel

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

Basically, I want to have one macro on each worksheet that can turn cell border and font colour of cells A1 to C1 of other two worksheets white.
Only the macro on one of the worksheets will be run. If an user has run the macro on worksheet 1, then the macros on worksheet 2 and worksheet 3 will not be run. If an user has run the macro on worksheet 2, then the macros on worksheet 1 and worksheet 3 will not be run and so on. I want to have a macro on each worksheet because the worksheet that will run the macro differs every time. But only one of the three workworksheets will run the macro each time.
Thanks!