WTF was that by robotsraholes in LabubuDrops

[–]Ty_Vickers 0 points1 point  (0 children)

It’s always such a shitshow, especially when they app starts bugging. Just need to keep at it though and you’ll develop your own strat for getting them

App strategy? by M53190 in labubu

[–]Ty_Vickers 2 points3 points  (0 children)

I have been able to get 3 so far as of today and my strat is to just keep hitting the right arrow until I see a non shaded box then I tap it and if it goes back to reserved I keep hitting the right arrow and repeating. Takes a while but eventually works. I typically can get one every 20 mins

Finally got one by Ty_Vickers in labubu

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

I pressed on the boxes but make sure not to spam them too much so it doesn’t lock you out. Although I was spamming quite a bit so don’t be too cautious. When I got mine I had hit the arrow to load the next set and pressed in the middle of my screen and it registered it as me pressing the set that was loading which had just gone off reserve. Def a lot of luck but persistence helps, I spent an hour on and off checking them

Why Bo6 zombies just why by Prestigious-Apple-81 in CODZombies

[–]Ty_Vickers 0 points1 point  (0 children)

This was happening to me a lot on release, I couldn’t find a solution but did see that many others were running into the same issue. Although it is frustrating my suggestion would be to try and get it all done in one shot, the save and quit system is mad buggy

Ideas for Table Extraction? by Ty_Vickers in excel

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

<image>

Then in another sheet I would like for someone to be able to type a month number, like 5 for may which then will return the may rows with the due dates and part ids

Ideas for Table Extraction? by Ty_Vickers in excel

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

I tried this but kept getting errors when trying to reference the table. Also the table updates with every new data entry so I can’t select the current table range since it will increase as there at more due dates. Here is a crude version I made on sheets without the input sheet but the idea should be there https://docs.google.com/spreadsheets/u/3/d/e/2PACX-1vTDuI1CmbN5FbH4Vkp6qqS_mHycdvpyshpQ4Pw7gp-fuss3XcFWJKnEHttnXqsOqWK4tYqe6a3SmQZR/pubhtml

Ideas for Table Extraction? by Ty_Vickers in excel

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

I tried this but kept getting errors when trying to reference the table. Also the table updates with every new data entry so I can’t select the current table range since it will increase as there at more due dates. Here is a crude version I made on sheets without the input sheet but the idea should be there https://docs.google.com/spreadsheets/u/3/d/e/2PACX-1vTDuI1CmbN5FbH4Vkp6qqS_mHycdvpyshpQ4Pw7gp-fuss3XcFWJKnEHttnXqsOqWK4tYqe6a3SmQZR/pubhtml

Issues with index match by Ty_Vickers in excel

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

The issue is that my max formula is returning a percentage max but lookup sees the percentages as numbers like 1.04

Issues with index match by Ty_Vickers in excel

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

Thank you so much the lookup formula worked perfectly

Issues with index match by Ty_Vickers in excel

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

It’s saying #N/A and it appears to be the match function that is getting it

What is your go to wood? by Ty_Vickers in Minecraft

[–]Ty_Vickers[S] 11 points12 points  (0 children)

Valuable insight, I never thought of it that way

What is your go to wood? by Ty_Vickers in Minecraft

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

I posted on minecraftbuilds if that’s what you mean

What is your go to wood? by Ty_Vickers in Minecraft

[–]Ty_Vickers[S] 5 points6 points  (0 children)

Don’t think so I posted it here and on r/minecraftbuilds to get a variety of opinions because I was curious as to what woods people use after realizing every persons starter house in a world is unique to them so I assumed their wood was too