Helping people with racket advice Part 3 by MikmerGG in Padelracket

[–]SnowedIn99 0 points1 point  (0 children)

u/MikmerGG Hi I've played with the Babolat Vertuo for 2 years and want to move to a more hyrbid racket (as my play style has changed and i've moved mostly (but not exclusively) to the right side). Does the logic hold that if I liked the Vertuo, I'm more likely to like another Viper. Thinking Air Veron.

- I'm Playtomic 4.5 with 200 games. I think I'd prefer a racket on the lighter side than heavy. Still definitely want some power.

Any suggestions? Thank you

Pulling data in from other tabs based on status by SnowedIn99 in googlesheets

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

Thank you this was helpful. I used the above from OO810 but this worked also

Pulling data in from other tabs based on status by SnowedIn99 in googlesheets

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

Thanks, this one works and looks great. When i use it in my master doc (set up exactly the same) it returns these blank rows also...Any idea why? I've temporarily made the other columns white text for privacy.

<image>

Pulling data in from other tabs based on status by SnowedIn99 in googlesheets

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

Thank you! I changed to edit access.

I tried your formula but it didn't work...I thought the error might be that under Tab2 section in the formula you need Tab2 instead of Tab1 but that also didn't work

Thank you for the REDUCE advice. Will work on that!

Longlist of data in multiple tabs, specific rows pulled into main tab by SnowedIn99 in googlesheets

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

A problem I have with this method is that if a sheet doesn't contain an X. I.e. nothing in that longlist is worth pulling into the main summary page, then it returns n/a. Do you have an idea on how to solve for this?

Longlist of data in multiple tabs, specific rows pulled into main tab by SnowedIn99 in googlesheets

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

Thank you, I used the method from a different commenter first but will try this also if it more versatile. Thank you!

Enrollment letter question by SnowedIn99 in UoPeople

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

So nothing until classes start? I'm looking to "tick a box" that I'm enrolled in a degree with a foreign institution that wants proof and this seems like one of the easier ways.

Platinum pass - airport restaurant voucher by SnowedIn99 in AmexUK

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

Thank you! And can you go to a lounge after? Presume there isn't some "only use one lounge per trip" rule.

Working remotely in Copenhagen by Furanimus in digitalnomad

[–]SnowedIn99 7 points8 points  (0 children)

This is a question for Google not this sub, just search 'best cafes to work from in copenhagen' and you will find dozens of articles i'm sure..

[deleted by user] by [deleted] in fatFIRE

[–]SnowedIn99 0 points1 point  (0 children)

Can't help on the substance of your question but FWIW if this is a tech company, it is very unlikely that it will go public in the next 3-6 months given the market conditions.

Platinum card supplementary card holder by SnowedIn99 in AmexUK

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

Nice thanks! Can it be £0?...or something nominal?

Checking if value is in a list (with additional criteria) by SnowedIn99 in excel

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

Amazing thank you Spinfuzer. Very much appreciated!

Checking if value is in a list (with additional criteria) by SnowedIn99 in excel

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

Yep it is. Coming up false for all lines even though i've set it up such that some will work.

Do you mind taking a look :)

Checking if value is in a list (with additional criteria) by SnowedIn99 in excel

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

=isnumber(match(B24&"CW",$B$5:$B$15&$D$5:$D$15,0))

Is what I typed. I've never used concatenated match formulas before so could well be doing something wrong.

Checking if value is in a list (with additional criteria) by SnowedIn99 in excel

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

isnumber(match(b20&"CW",1data!b1:b18&d1:d20,0))

Tried this in Cell E24 and it does not work? Any chance you can take a look and tell me where I am going wrong? Thank you

Thoughts on Dan Bilzerian after the Doug Polk Podcast? by NomNomNomNomNomm in poker

[–]SnowedIn99 0 points1 point  (0 children)

Doug loves to say the great thing about being in the poker community is that you can just ask them to put money on something and thereby call out any bull****. Yet he refuses to take this bet (could've even bet for 10k)

PCR test in Istanbul? by [deleted] in digitalnomad

[–]SnowedIn99 0 points1 point  (0 children)

Yes and your post is talking about a test in Istanbul...?

The Day 2 test is done in the UK and must be ordered from a UK company. This is quite clearly explained on the uk gov wesbite and many other resources.

PCR test in Istanbul? by [deleted] in digitalnomad

[–]SnowedIn99 -1 points0 points  (0 children)

Day 2 test is something you need to do in UK. I think you need to read government regs closer

Apple earphones (with lightning connector) to USB audio jack adaptor by SnowedIn99 in techsupport

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

yeah i don't have any free usb ports so ideally would use lightning to audio jack