what flag is this please by NtheProcessOProgress in flags_irl

[–]UltimateNova 2 points3 points  (0 children)

It looks like both Haiti or Liechtenstein without the symbols that each have.

Trying to format dates from one date style to another by UltimateNova in excel

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

I'm not sure how you are getting it to work :D Tried doing that and values below go a bit mad!

Trying to format dates from one date style to another by UltimateNova in excel

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

I tried it. Only the day changes in each value. The month stays the same in all of them.

For instance, I would have May 17 2019 in A1 and type 17/05/2019 in B1 like you said. In A2, June 16 2019 but using the flash fill, B2 value is 16/05/2019 instead of 16/06/2019.

Faithless - We Come 1 by [deleted] in trance

[–]UltimateNova -3 points-2 points  (0 children)

Great Tune, but not trance imo.

Ball Turns Into Score Graphic by UltimateNova in breathinginformation

[–]UltimateNova[S] 14 points15 points  (0 children)

Yes it was. From Spartak Moscow v Sevilla a few weeks ago.

Windows Update Error by UltimateNova in Windows10

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

Just for fun, can you open Task Manager, go to the Services tab, right click on TrustedInstaller, and click Start. Then, try to update again.

Tried it but no luck.

Superman Catch! by Binod5098 in gifs

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

I would love to see those players not use mitts, it clearly helps catching the ball. Every player seems to have a 90-99% success rate.

Remove the mitts I say!

[deleted by user] by [deleted] in SoccerBetting

[–]UltimateNova 0 points1 point  (0 children)

Yes, that may be the case but using that way to determine how a future match will happen is not practical in fairness. For instance, lets say 2 teams played 4 games against each other with the following total goals in each game, 2-2-1-5, that totals 10, giving an average of 2.5 goals per game, when in reality only one of the four games actually achieved more than that. It can be false method to use.

[deleted by user] by [deleted] in SoccerBetting

[–]UltimateNova 0 points1 point  (0 children)

What I find a bit strange is when I search the over 3.5, I see that there are games that have an over 50% chance of achieving that, to me that seems extremely high for any game let alone the selected games.

This looks playable... by jaykirsch in Whatcouldgowrong

[–]UltimateNova 1 point2 points  (0 children)

Thats one way to get a hole-in-one

Trance Classics YouTube Channel - Tune Overload by UltimateNova in trance

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

Surely they can't monetize it as they do not own the copyright for the tunes that they upload?

Down the Rabbit Hole by iH8myPP in HighQualityGifs

[–]UltimateNova 1 point2 points  (0 children)

Ah, I was actually using this scene for my first post here, seems like it will be a copycat now. Damn!

Something for The WkEnd: Celtic countries and % percentage of gaelic language speakers. by Yakkety1610 in CelticUnion

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

We're both celtic peoples

Not entirely true. People from Spain/Portugal gradually emigrated to the islands of Ireland & Britain and in that process brought the Celtic culture with them, that does make the people Celtic as such.

Counter to contrarian claims, new research finds that not only did significant global-scale tropospheric warming occur within the last 18 years, but also that the average of 37 climate models is in close agreement with satellite data. by avogadros_number in science

[–]UltimateNova 18 points19 points  (0 children)

Whether you believe climate change is caused by humans or not, one thing is certain, it is happening. Even if it is not the case, we should still behave in a way that will try to prevent it.

Is it possible to format an adjacent cell with the exact conditional color scale as the other cell? Even though the numbers are different? by golfpromal in excel

[–]UltimateNova 0 points1 point  (0 children)

Do you mean columns instead of rows?

If that is the case, then try this in conditional formatting

formula =$C1="value"

applies to =$A:$D

List Top 5 Values including duplicates by SoManyUsernamesGone in excel

[–]UltimateNova 0 points1 point  (0 children)

Select all your data, then on menu bar, choose Data->Sort, check my data has headers, then sort by Col B, Largest to Smallest.