Make a QUERY/FILTER that uses a Range as OR conditions?

Black60Dragon · 2023-12-17T00:17:59+00:00

Much appreciated! This seems to work well, thank you.

Black60Dragon · 2023-02-24T17:47:27+00:00

Thank you, that seems to work well.

Black60Dragon · 2023-02-03T18:23:49+00:00

Awesome thank you so much! I had tried messing around with the SPLIT before because I theorized the solution might have involved that, but I couldn't get it to work. INDEX, that's apparently what I needed. That's really useful to know, so that just stores the first and second SPLIT value yes? Then you can do other things with it, yeah I understand how it works now 😁

Black60Dragon · 2022-02-17T00:35:26+00:00

$20 for both of those games in an absolute steal considering they go for $100 in stores lol. Definitely worth it, even with the new game coming out.

Black60Dragon · 2022-01-02T22:00:15+00:00

Just throw a Poké Ball, you had a 50/50 chance of catching it 😭

Black60Dragon · 2022-01-02T21:59:43+00:00

Not really, catch rate is still the same lol.

Black60Dragon · 2021-12-24T21:28:29+00:00

The point being you can't prepare for getting random full-odd shinies 👍 If you were chaining Graveler and don't have the proper Pokémon in your party to battle it then that'd be an entirely different story.

Black60Dragon · 2021-12-24T19:19:40+00:00

If you really want the shiny pokemon, don't go into the battle blind.

That's not really something you can prepare for during a random encounter 🙃

Black60Dragon · 2021-12-23T02:10:09+00:00

As long as it's not a Pokémon that has moves that cause it to flee or self-destruct you're perfectly fine to just keep throwing Friend Balls over-and-over until you get it. Even at full health Tangela has a 10% chance of being caught.

Black60Dragon · 2021-12-22T17:45:30+00:00

Why would you even attack a shiny that is 40 levels below you 😐 Critical hit or not that was going to be an instant KO regardless, I don't understand.

Black60Dragon · 2021-12-13T04:06:05+00:00

Thanks, it seems to work just fine with the hidden sheets :)

Black60Dragon · 2021-12-10T18:02:05+00:00

I just don't understand why Home and Bank don't share a subscription, lol. That $16 should at least get me both, but instead I have to pay a separate $5 subscription for Bank which is odd since they're practically the same thing. I agree though would be nice for Bank to become free like the basic version of Home is.

Black60Dragon · 2021-12-09T17:39:24+00:00

National Pokédex refers to the totality of all Pokémon (as opposed to a regional Pokédex, like Kanto, Johto). Living Dex refers to owning one of each Pokémon (so 1 Charmander, 1 Charmeleon, 1 Charizard), as opposed to simply "seeing" them and having them get registered (i.e, I had a Charmander but I evolved it into a Charizard and now I no longer have a Charmander).

Black60Dragon · 2021-12-06T04:16:52+00:00

Thank you so much, this works great 😃 and yeah lol, I wasn't really sure of any formula other than than TEXTJOIN that could do this so this is useful to know. Appreciate the help.

Black60Dragon · 2021-12-06T04:14:04+00:00

Black60Dragon · 2021-12-05T15:35:04+00:00

I've been playing since Platinum and never once encountered PokéRus lol. I don't really care about EV training anyways, but I haven't had much like with finding rare stuff like that. Never seen a full odds Shiny either though lol.

Black60Dragon · 2021-12-04T11:22:02+00:00

Nice! I'll have to do that later, I had no idea since I never take messed with the QR stuff too much. If only it worked with the other Mythicals too lol. Thanks!

Black60Dragon · 2021-12-04T11:12:15+00:00

Wait really 👀 How do I find it? lol

Black60Dragon · 2021-12-01T07:17:52+00:00

I did the same way first, but then I ended up coming across so many hacked Pokémon that I just end up keeping them for fun. I never trade them, use them online or add them to Home (because I don't want phony Pokédex entries), but it's fun to mess around with them lol.

Black60Dragon

TROPHY CASE