This site under reconstruction.
Fast Company had an article titled “Are You Ready To Consider That Capitalism Is The Real Problem?” Wow. A young college student asked Nancy Pelosi that question and she responded with “No, I’m sorry to say we’re capitalists and that’s just the way it is”.Capitalism has done a lot of wonderful things for us but…
Almost daily I get these news-emails about finance but I have never subscribed to them. They just started appearing in my work inbox one day. When I get stuck on a problem, I will turn to these news-emails to see what “they” (whoever they are) are trying to sell me. The news-emails are written like…
Have you ever tried doing an autofit of a row by placing your mouse to the far left of the file, to the bottom of the row, and right clicking your mouse and nothing happens? It might be because you have merged cells in one of the columns.But sometimes you need those merged cells. For…
Have you ever done a VLOOKUP only to find that the words run into each other, but when you look at the source, the words are beautifully spaced? You end up with something like: “Priced by volume:$100 buy in volume of 200$150 buy in volume of 300$200 buy in volume of 500”? If you look…
Before progressing on to the other puzzles in the HR Compliance reporting that I started in the last post, I wanted to provide another example of using arrays as a searching tool when VLOOKUPs or INDEX/MATCH do not work. The more times you use this kind of array formulas, the easier it is to understand….
This post will go over some of the solutions I’ve thought of to enable automating the HR/Legal Report. I haven’t finished yet, namely because there are a bunch more downloads that I’m supposed to receive, and because there are a few issues I still need to work out, but I thought I would provide a…