This site under reconstruction.
I’m definitely suffering from low motivation – I just want to sit and look at videos or TV. Feeling meh even though I know I have stuff to do. Thankfully, I did do some stuff yesterday. Tonight, I thought I would do a post to try to make up for the meh feeling. A couple…
Real quick post tonight because it is late. The stuff I was trying to do today took all day long – I had hopes on getting this particular task done further along but instead it is taking a long time to run. Anyway, I wanted to do a quickie post on those new functions that…
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…