This site under reconstruction.
I’ve noticed that states have stopped reporting coronavirus status every single day, including the weekends, especially in the South. I get it…we’re getting tired of keeping track of how we’re doing (or how we’re not faring). Florida, though, is a state that is on another level so that now my graphs are starting to be…
Do you ever run into a situation where you try to pull in data into your Excel via Get Data in the Data tab but there is more data than rows available in your file? I used to use Access for those situations, but lately it looks like Microsoft, maybe since last summer, has revamped…
I may have mentioned this idea before in another blog post but it’s worth repeating again because it is simple enough. It has to do with VLOOKUP. The layout for this function is: VLOOKUP(lookup value, table array, column index number, true/false) Example: =VLOOKUP(C5,Table!B2:I53,2,FALSE) Column index number is usually hard coded in as a number and…
I was doing a bit of research today to see if I could utilize Microsoft’s Power Automate (or Power Flow?), but alas, no, it does not appear that I can – at least not in the fashion that I would like. Here’s a couple of things I learned: Unfortunately, the only Excel Power Automate will…
In my last post I mentioned that I had created some VBA programs to update my nightly pulling in data. Now it’s been about a week and is really is fast. Today I just finished up the last macro that I wanted to create and I will be testing it tonight, but already, the speed…
