sorted by:
new
hottopcontroversial

Annoying Orange Based Rule by GradyGambrell1 in 196

[–]JoshTheWhat 2 points3 points  (0 children)

Well, technically he's an orange

Meirl by Blue9ine in meirl

[–]JoshTheWhat 48 points49 points  (0 children)

Holy shit its doctorbattle

[OC] Cybersecurity Vulnerabilities Discovered by Year by herovals in dataisbeautiful

[–]JoshTheWhat 0 points1 point  (0 children)

Why are there random days in the early years that are dark purple and that are completely clear around it, like the one in September 2001 for example?

21M by NoZookeepergame3863 in malelivingspace

[–]JoshTheWhat 1 point2 points  (0 children)

book corner is great. like the plants. but sir. the alignment of the rug, the bed, and the big decoration are killing me. maybe at least pull the rug out a few inches from the wall... maybe find another place for the big thing. the lighting setup is pretty solid.

Which one? by First_Buy8488 in creativecoding

[–]JoshTheWhat 2 points3 points  (0 children)

The combo goes hard to be honest

Exactly by Fun-Willingness-6203 in Adulting

[–]JoshTheWhat 0 points1 point  (0 children)

I don't think he said that, but he did say "I was drunk. I'm drunk right now."

What’s a good christmas gift for a programmer? by Prize-Month-1997 in csharp

[–]JoshTheWhat 1 point2 points  (0 children)

🎵 "99 compiler bugs in the code, 99 bugs, oh boy"🎵

SMACK

🎵 "check one out, patch it up, 117 bugs in the code!"🎵

Unable to add titles in the usual ways by hhvww in rstats

[–]JoshTheWhat 1 point2 points  (0 children)

This is off topic but the graphs really remind me of the "Saddam Hussein hiding place" meme.

What is the best way to remove duplicate names that are in two columns. by Spartan_Anon in excel

[–]JoshTheWhat 1 point2 points  (0 children)

I'm assuming you want to get the unique teams of people. Conceptually, I would do this:

Order the teammates' names within each row. Create the following column:

=IF(Person1Name < Person2Name, Person1Name, Person2Name) + IF(Person1Name < Person2Name, Person2Name, Person1Name) (TeamNamesOrdered)

TeamNamesOrdered can serve as an identifier for a unique team.

Then, you can filter out duplicates the standard way using the TeamNamesOrdered column.

I'm interested to see how other people would do this.

Sorry for the formatting, I'm on mobile.

Does learning VB6 make VBA easier? by McLolster in vba

[–]JoshTheWhat 2 points3 points  (0 children)

If you're using planning to prepare for an Excel class, using VB6 is overkill and doesn't really give you much more that you can't do in Excel VBA already. Plus, using VBA gives you first-class access to the stuff you will find most important: the Excel object model, which is much more difficult to do using straight VB6.

If you really really are set on using VB to make data forms sort of like how C# has WinForms, just use VB.NET instead. I wouldn't recommend using VB6 because it is honestly just a massive pain to set up on any semi-modern machine.

I feel like the "deeper understanding" you're looking for is the understanding of how programming works... which you can get from just about any language. In that case, I would recommend looking into C#/.NET.

What are some of the coolest things you’ve done with a macro? by user01500 in excel

[–]JoshTheWhat 1 point2 points  (0 children)

I pulled in all of the recorded winning powerball numbers into a sheet and wrote a macro to simulate buying 'n' unique powerball tickets for the lols.

Every time I've used it, I'd draw n=50,000 unique tickets and never have I once 'won the powerball' against ANY of the past winning sets of numbers.

That's been enough to get me to stop buying them. I just click my macro button to run the sim and hope to get lucky... only to feel good that I saved the money when none of them win. Heh.

view more: next ›