From one of my more advanced courses at Weber State, we were instructed to build a program that would build a database out of tweets online meeting a specific search criteria. It would search for tweets with a specific word or phrase in a given geographical range. Then it would pass the text to a …
Bridgeland Water Company consulted with me on a quick solution to switch from mailing out their billing to Emailing. As a result I whipped up a quick Excel macro that would read their data and put together an email for each entry. This was a fun project. I had already experienced using VBA to manipulate …
I built a program that Calculates the probability for the Liars Dice game. Liars Dice is the iconic gambling game from Pirates’ of the Caribbean. It was a popular game among my friends. So, for fun, I thought to make a program that would perform calculations for me to help me play. To sumerize the …
At one point in my career I was asked to export a table that was over 2,000 columns long from one of our applications and read it onto a SQL server. Through trial and error I learned several important rode blocks to doing this. The first was that there is a 1,024 column limit for …
I know of three different ways to join together multiple tables of data. The first two are well known; use a vlookup function, and use Power Query Editor. But vlookups aren’t static calculation and can really bog down an excel document if your working with large amounts of data. If you have 10,000 rows for …
Alternative Method to Joining Tables in Excel Using Remove Duplicates Read More »
