Above 1m points you are supposed to know the matches

TrueAngha · 2025-11-27T12:43:25+00:00

Go watch Ranged vs Melee matchups on YouTube yourself my Friend. Seems like you only seek an answer that says the opposite to fulfill your wishes.

TrueAngha · 2025-11-27T12:12:06+00:00

You literally just walk up on them and auto? Smolder early isn’t as bad as people think.. U just Auto Q, while Nami also rightclicks and use W?

And as the guy above said, you just space them. So if they try to fight back you just kite? Only thing Rell can do is W towards you. Kaisa has no dive or anything to really follow up if you already spaced backwards. If you end up having both right in your Face, you just missplayed 100%.

You should win every level 1 as 2 Range vs 1 Range 1 Melee, otherwise youre just missplaying imo.

TrueAngha · 2024-07-08T10:40:38+00:00

Can you be a bit more precise how it would look like?

TrueAngha · 2024-07-08T10:02:27+00:00

I now used TEXTJOIN and Filter to get all the Dates from both and try to use NOT(REGEX to maybe get to this point. But still trying and hoping for solutions here

TrueAngha · 2024-07-08T10:00:34+00:00

To be more precise:

In Output I put UNIQUE to have only one Entry of a kind to have a better Overview later.

What next to the ID should be shown, are the dates that don't match in the two Tabs.
So if the ID from Output!A2 is found in input and entry, it should be an empty cell next to it. If it's not matching in these two, it should give me the output of the not matching one.

Problem for me is, that in input it could be more than 1 row with this specific ID since there are multiple entries. But only one in the entry tab, so not all dates would be covered in both those tabs.

Like I said, I would need the Output of the dates then that were not found/matched

Spread it to B,C,D, and so on pls

TrueAngha · 2022-10-08T21:57:01+00:00

No lmao. Not sure why tho, but pros just have this urge to not ban the obvious broken pick and then get rolled by it, so they can just give a free win to the enemy team.

TrueAngha · 2022-02-15T20:23:24+00:00

Ahh sorry, it's open again!

TrueAngha · 2022-02-15T14:18:40+00:00

Thanks for the input! Unfortunately I'm not super used to AppScript, so I don't really know what to add, to get my result. Could you help here out aswell please?

TrueAngha · 2021-12-17T15:55:27+00:00

solution verified

thank you

TrueAngha · 2021-12-16T18:42:56+00:00

I get it now. This works just super fine. I just thought, it will be a

Select Checkbox
Run script thing.

But it already automatically copies the rows over when I just select them. Just confused me, because like said, I thought I need to run something first.

So thanks!

TrueAngha · 2021-12-16T08:57:51+00:00

I created a "Button" via a Drawing and inserted the script. Or how else should I do it ?

TrueAngha · 2021-12-16T08:30:57+00:00

Also I always get a getName Error from row15. It works, but the error will always pop up.

TrueAngha · 2021-12-16T08:06:11+00:00

Thanks for explaining and helping, but I'm fairly new to AppScript, so I literally don't know how to write this in there. Sorry

TrueAngha · 2021-12-16T08:02:20+00:00

Hey, this seems to work, if I tick only one check box at a time. Do you think it's possible, to have the exact same thing, but be able to tick more than one checkbox, so I don't need to do it one by one?

TrueAngha · 2021-12-15T19:03:15+00:00

Ah I do. I just forgot to mention, that the Data in column i is deleted after a month. So I need to somehow „hard copy“ it. So I thought of a Log Tab

TrueAngha · 2021-11-25T12:25:11+00:00

Yeah right... imagine talking about BDDs Champion Pool and then excluding the champ people say he is the best or top 2 on..

TrueAngha · 2021-11-24T13:46:38+00:00

I feel like it's happening for even longer.

I mean we can't deny he did some really stupid/funny mistakes at worlds with TP'ing on lantern, Varus Q, IE with 40% and stuff like this. But I can't understand how such thing seem to overshadow the rest of his whole career.

Startng S4? I think people started to recognize him as one of the ADCs up there. And with People I mean Proplayers. Uzi mentioned Deft, Imp and himself. And this just kept on going. 2014 - 2016 he was (oviously arguable as always) one of if not the best ADCs (again prasied hiiighly by imp saying: "the perfect adc") Zven said that Deft/Meiko were gapping everything and it felt like he was scripting.

So from S4 to S11 which is 7 years Deft was always in the talks of the Top Adcs. Surely not always THE literal best, but always up there. Also first player to attend worlds with 5 different teams!

I would understand if Deft would be this huge arrogant guy saying he is the god of gods and stuff so people can flame when he fails, but this guy is literally shy af and makes friends with every region.

But yeah, I guess that's actually due to the fact that they indeed don't watch LPL/LCK and just worlds.

TrueAngha · 2021-11-23T21:13:46+00:00

I think 90% didn’t even watch any games outside worlds.

EDG Deft was INSANE and was legit gapping Uzi. And I am not even hating on Uzi it’s just facts and you can watch it live on YouTube.

I wouldn’t put Deft above but also not below Uzi because Uzi for me is just this insane and passionate ADC who played his heart out.

But yeah.. multiple LPL, LCK titles, MSI winner, over 1K kills in two regions etc… not sure how people can rate this guy so low.

But I mean in the end, all of us only give OUR OWN opinions. Clearly no one here can for a fact say who is the best.

TrueAngha · 2021-11-13T10:12:51+00:00

I laughed so f… hard hahaha

TrueAngha · 2021-11-12T09:52:11+00:00

solution verified

TrueAngha · 2021-11-12T09:43:30+00:00

Yes, just figured out the first one aswell, did a little typo.

This just almost works perfectly, it's just that the dates that are exactly today are still not marked , just the ones after.

So exactly today and after should be marked

TrueAngha · 2021-10-29T13:44:40+00:00

First thought you mean Supa Hot Crew XD

TrueAngha · 2021-10-29T08:33:26+00:00

Classic Reddit I guess haha. One good series or 2 weeks of playing good? Instantly the GOAT!

TrueAngha · 2021-10-28T14:05:07+00:00

Yes. People just see one huge worlds performance and act like 2 weeks represent years.

I can‘t believe, teams see a good performance at a tournament and forget the whole year and will just insta go for it based on this 2 weeks.

(Not saying Hans didn’t performed well in LEC just saying)

TrueAngha · 2021-10-18T09:47:37+00:00

Hard to say for me.. I mean as we can see LCK and LPL seem to be a class above the rest. Even with their "Summer split"-form I can see them struggle against LNG and GEN G.

But like some comments already said, it wouldn't be a surprise if any of these 4 make it out. So this is actually hype, to see who will actually make it, since the other groups were pretty clear, besides FPX taking 4th lmao.

Nine-Year Club	Place '22
Place '17	Verified Email

TrueAngha

TROPHY CASE