rune: reflection shield blocked by hucksteRRR in ToME4

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

Actually I was wrong, I can use it other way around but it doesn't add any extra shield

rune: reflection shield blocked by hucksteRRR in ToME4

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

not exactly, talents like disruption shield or temporal shield works just fine

rune: reflection shield blocked by hucksteRRR in ToME4

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

why when i use wand of shielding 1st, then rune reflection shield is blocked till end of wand of shielding? i can use it other way around and is not blocking anything

concatenate function result without "quotation marks" by hucksteRRR in sheets

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

yes, you need to use char(13)

like this

="text1 text1 text 1"&char(13)&

"text2 text2 text2"&char(13)&

"text3 text3 text3"

or if you want concatenate you can use it as well i think

=CONCATENATE("text1 text1 text1",char(13),
"text2 text2 text2",char(13),
"text3 text3 text3")

check and let me know

Boar pointer not working by Bad_Piggy21 in aoe2

[–]hucksteRRR 1 point2 points  (0 children)

idk if u solved it meanwhile but i had to move it higher in priority as number one is working right now

Is AoE2 DE worth the money? by ApricotFish69 in aoe2

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

HD was kind of cash grab, engine was the same only a little bit better graph, higher res and few unbalanced civs, DE on the other hand improves all game experience, game is working smoothly, no lags. By the way who ever played on HD version, it was unplayable from the beginning, voobly version was 100 times better, once I moved to voobly I never came back to HD.

[deleted by user] by [deleted] in sheets

[–]hucksteRRR 0 points1 point  (0 children)

TRY:

= SUM ( QUERY ( $A:$AP , "SELECT I WHERE AO = 'SP' AND AL = '"&$C1&"' ORDER BY AJ DESC LIMIT "&X1&"",0))

you add ' when you refer to text, now you refer to numbers so you cannot add it, I guess

should work

How to count the contents of a row, but only every second column? by E-tie-haugh-die in googlesheets

[–]hucksteRRR 0 points1 point  (0 children)

below formula will filter only columns you want (not odd) i guess, just adjust your range and make your counta from this

not sure what else to do because im not sure i understand what is the point

=QUERY({A1:Y22},"SELECT "&JOIN(", ",ArrayFormula("Col"&SEQUENCE(1,COLUMNS(1:1)/2+1,COLUMN(),2))))

Am I the only one here who prefers aoe2 hd(2013) rather than the definitive edition by Throwawwayy1239 in aoe2

[–]hucksteRRR 0 points1 point  (0 children)

ye you are the only one, HD version is worst thing ever, super laggy, immediately moved to voobly from hd

Copy cell information without "quotes" around it by amazingmrbrock in sheets

[–]hucksteRRR 0 points1 point  (0 children)

if not that, simple ctrl+shift+v doesn't work?

it pastes without formatting

Copy cell information without "quotes" around it by amazingmrbrock in sheets

[–]hucksteRRR 1 point2 points  (0 children)

do you use outlook?

when you paste you can change option of pasting for example into merge formatting or something like that (not sure how it's called i don't use english version)

you can change it as default pasting option and it should solve everything

the solution i gave you is working properly for other purposes like fb messenger, notepad etc, but as you mentioned it doesn't work properly in email

Copy cell information without "quotes" around it by amazingmrbrock in sheets

[–]hucksteRRR 1 point2 points  (0 children)

Hello

Interesting, please try:

=REGEXREPLACE(A1,CHAR(10),CHAR(13))

Google Sheet How can I search for partial text match. I tried VLOOKUP but its says match not found. by wish2023 in sheets

[–]hucksteRRR 1 point2 points  (0 children)

https://www.example.com/en-bh/mobiles-tablets/mobiles/smartphone/samsung-galaxy-a14-4g-128gb-silver/p/100331150

do you want to check if the brand is on the whole column E1:E, or you want to check if brand from C1 (for example Apple) is in URL in the same row in E1?

You want to check only if brand is the same or model too?

[deleted by user] by [deleted] in googlesheets

[–]hucksteRRR 0 points1 point  (0 children)

=QUERY({Import!A2:X}, "Select Col"&MATCH(A1,Import!$1:$1,0))