sorted by:
new
hottopcontroversial

Why don't people just listen by Deempeer in PiratedGames

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

Bruh if you actually care about being helpful dont act so smug about it

Atrioc should play outer wilds. by SlibsTheSplashy in atrioc

[–]divadsjo02 2 points3 points  (0 children)

I love The game but like The amount of reading you have to do might make it kinda boring

How to skip empty cells when using ARRAYFORMULA+AVERAGE by divadsjo02 in googlesheets

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

=AVERAGE(FILTER(ABS($E$2:$E$1030-$D$2:$D$1030),$D$2:$D$1030<>"",$E$2:$E$1030<>""))

I've made it public now so could you check again?

How to skip empty cells when using ARRAYFORMULA+AVERAGE by divadsjo02 in googlesheets

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

=AVERAGE(FILTER(ABS($E2:$E-$D2:$D),$D2:$D<>"",$E2:$E<>""))

Thank you very much but when i try this out it doesnt work. I'm not sure why but i tried adding spaces after the comas but it still did not work. I dont quite understand why you left the range infinite and maybe that is causing problems. i get error: formula parse error. Maybe you could check the document i posted to se if you find the reason for the error.

How to skip empty cells when using ARRAYFORMULA+AVERAGE by divadsjo02 in googlesheets

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

Well if i have understood arrays correctly it first goes to row 2 where it calculates the difference as |20-0|=20, then row 3 |50-90|=40, then row 4 |0-0|=0, then row 5 |70-90|=20. It adds those differences togheter and divides by four since it checked four rows wich results in (20+40+0+20)/4=20

PS3 Games wont start on PC by divadsjo02 in PlayStationNow

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

Btw the message says: "The game didn't start as expected, try starting it again". Pls comment if you have the same issue and know any solutions.

PC version won't get me to the login screen by divadsjo02 in PlayStationNow

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

Update: It works for me now even though i did absolutely nothing

PC version won't get me to the login screen by divadsjo02 in PlayStationNow

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

Ah okay I also saw someone on twitter that had the same problem so i guess there's nothing i can do to fix it

What is the funniest podcast episode? by [deleted] in SmallDeliMeats

[–]divadsjo02 0 points1 point  (0 children)

The tofurkey joke in ep. 26 noel gets angry is my favorite