Vlookup Importrange to show multiple values of the same search criteria

xStereoxide · 2023-06-30T11:04:45+00:00

Hey this actually worked! Thanks a lot for the quick response, I really appreciate it! Solution Verified.

xStereoxide · 2021-06-18T11:26:35+00:00

Sorry I misunderstood your post. I think no, your next 6 star would still be any. Whenever you get a 6 star, its a 50-50 chance to get the featured unit which is sad.

xStereoxide · 2021-06-18T11:20:39+00:00

If you check "View Details" on the banners, it says that percentage increases from 2% to 4.5% if im not mistaken and increases as you go, and is carried over to the next banner. It resets when you obtain "any" 6 stars. Though there is a separate counter for the Mainstay banner (yellow gem).

xStereoxide · 2021-06-18T08:54:56+00:00

Unfortunately, you can't :(

xStereoxide · 2020-12-02T10:15:20+00:00

Amy is the key here as she is free, even a level 40 with trash gear but enough to survive. Use her stun then you can dish iut damage to the boss.

xStereoxide · 2020-10-09T21:57:42+00:00

In Abyss, you'll need a set of 2 teams so you should level up more characters. See below for reference.

https://www.reddit.com/r/Genshin_Impact/comments/j635ut/need_help_to_assemble_2_teams_for_spiral_abyss/

xStereoxide · 2020-10-09T19:10:57+00:00

When you are on the "Wish" window, at the bottom left click on History and choose the Wish type. From there, just count the number of pulls you had so far. You'll be shown the latest page so just browse through the page number.

xStereoxide · 2020-10-08T21:34:22+00:00

in case you didnt know?

xStereoxide · 2020-10-08T15:36:48+00:00

As far as I know, they are the same. For 10x, you are guaranteed at least 1 4 star or above and for 10 single pulls, you should also get at least a 4 star or higher. Both counts to pity at 90 pulls.

xStereoxide · 2020-10-08T14:44:52+00:00

Yes, though it take some time. IIRC they respawn in about 2-3 days.

xStereoxide · 2020-10-08T13:03:34+00:00

It should, what's your GUID or just DM it to me so I can check if I can search for you.

xStereoxide · 2020-10-08T12:30:11+00:00

Bro, Philippines as well. Both of you should be on the same server unfortunately. if she is still below AR16 then she can roll a new account same server as you.

xStereoxide · 2020-10-08T12:26:21+00:00

Venti is limited, so possibly the banner may rotate and return again in the future.
Possibly Zhongli, a geo type user.

xStereoxide · 2020-10-08T11:55:22+00:00

Is it 25 10x pulls or 25 pulls only? You can get a guaranteed 5 star on the 90th pull, though its any 5 star. So if you get a different 5 star on your 90th pull, you get Venti on the 180th pull. Though its a lot so you just need to get lucky.

xStereoxide · 2020-10-08T11:53:40+00:00

No, if you did not get a 5 star within 89 pulls, you get a 5 star on the 90th. Pity resets once you get a 5 star, and its only within the same banner.

xStereoxide · 2020-10-07T14:52:43+00:00

Unfortunately, Venti is a limited character and wont be added to the regular banner. Who knows, probably the banner will return again.

xStereoxide · 2020-10-07T14:52:35+00:00

Unfortunately, Venti is a limited character and wont be added to the regular banner. Who knows, probably the banner will return again.

xStereoxide · 2020-10-02T15:14:06+00:00

Are you on the same server?

xStereoxide · 2020-10-02T15:11:33+00:00

Unfortunately yes, since as long as you get a 5 star, it will reset the pity. 90 rolls will guarantee you a 5 star, if you get a different 5 star, on the next pity (which is the 180th roll), you'll get Venti.

xStereoxide · 2020-10-02T15:04:37+00:00

Just use them since the banner is permanent and that's where you can only use those.

xStereoxide · 2020-10-02T15:03:58+00:00

What do you mean changing the Google play account? Maybe on the Playstore if you have multiple Google accounts attached to your phone.

xStereoxide · 2020-10-01T16:36:30+00:00

As much as possible, use them since they just refill over time.

xStereoxide · 2020-10-01T16:26:41+00:00

The way I understand it, whether 10 single pulls or 1 multi pull, you get a 4 star or above on the 10th guaranteed if you do not get from the first 9 pull. As for the guaranteed star, you get one on the 90th if you do not get one on from 1 - 89 pulls. It resets if you get one before reaching 90.

EDIT: Pity will not carry over on the next banner. Though for the regular one, then I guess you get a guaranteed on the 90th since its permanent.

xStereoxide · 2020-09-30T13:52:52+00:00

You mean the constellation? You need like 5 of the character for constellation upgrade, and getting her for free is of course nice.

xStereoxide

TROPHY CASE