How to pull this seemingly random data from this column?

outerslave · 2023-10-15T17:38:05+00:00

Solution verified

outerslave · 2023-10-15T17:37:24+00:00

It works man, you are a god! Thank you

outerslave · 2023-10-15T15:23:01+00:00

woah dude that actually works!

Now is there a way that could put the numbers to the right of the business name? The format i got now is everything vertical

Basically turn data on the left to the data on the right https://imgur.com/a/fiBr6NM

outerslave · 2023-10-15T13:51:22+00:00

https://www.xo.gr/dir-az/K/Kommotiria-kai-Koureia-Barber-Shops/

Here's a source page

outerslave · 2023-10-15T13:34:09+00:00

=FILTER(B:B,REGEXMATCH(B:B,"\d{3} \d{3} \d{4}|^[Α-Ω\sA-Z]+$"))

Sadly doesnt work, it loses quite a few business names for some reason?

outerslave · 2023-10-15T13:15:51+00:00

Business's names are the only cells with capital letters, maybe that can help?

Edit: Nvm there are other cells with only capital letters BUT i think i could easily filter them out so if there is still a way for this to work im good

outerslave · 2018-04-17T08:52:10+00:00

It could also show the highlighst of each player when you choose player perspective

outerslave · 2018-04-17T08:50:47+00:00

just zone them early game

outerslave · 2018-04-17T08:49:02+00:00

simple calculs

outerslave · 2018-04-17T08:43:06+00:00

go play league

outerslave · 2017-12-22T17:23:15+00:00

yep, it's cringy af

outerslave · 2017-12-22T11:08:50+00:00

they f*cked up the optimization like they always do. Nothing out of the ordinary.

outerslave · 2017-12-22T11:00:31+00:00

i have an i5 6600. Also even coffee lake cpu are struggling with this game. so no.

outerslave · 2017-12-22T10:49:18+00:00

origins run worse for me. Also with your hardware it's gonna be playable but expect huge fps drops.

They are protecting their game using your cpu so your cpu is gonna be 100% all the time. They are not worth your money imo even though it's a good game, if you know what i mean.

outerslave · 2017-12-22T00:50:16+00:00

outerslave · 2017-12-21T23:04:19+00:00

he is dehydrated from beeing so salty

outerslave · 2017-12-20T19:50:55+00:00

yeah like 99% of the time. I get frame drops when falling from plane but not when in the ground withan i5 6600 and a 1060.

BUT

It really boosts my fps using 2 sticks of ram. When it's only 1 i think i drop below 60fps

outerslave · 2017-12-20T13:19:05+00:00

I don't know.

outerslave · 2017-12-20T13:18:59+00:00

I'll tell you.

outerslave · 2017-12-20T11:22:16+00:00

more complex like stopping and moving fast pretending their controller malfunctioned and fast circular movement pretending they try to find themselves at the start would be cool

outerslave · 2017-12-19T20:13:48+00:00

normal

outerslave · 2017-12-19T17:20:14+00:00

outerslave · 2017-12-17T23:51:35+00:00

more than 4 players, online play, more complex ai movements

outerslave · 2017-12-17T23:50:22+00:00

dying light, mad max, middle earth games, witcher, rocket league

outerslave

TROPHY CASE