You have an Excel file with thousands of rows like in the below image and for each row you need to extract the file name: How would you do this ? Solution: One formula that can solve your problem is this one: =RIGHT(A3,LEN(A3)-FIND(“$”,SUBSTITUTE(A3,”/”,”$”,LEN(A3)-LEN(SUBSTITUTE(A3,”/”,””))))) Let’s explain how it works: The file name is the sub-string after the…
In this post I show you how to Import in Excel exchange rates from a webpage using VBA Internet Explorer Automation. You will also learn to use some nice formulas (date formulas, counta, indirect, text) and create a dynamic chart to represent the trend of the imported data.
Excel model used to track and report the data regarding your personal income from the companies you worked for. At the end of the post you can also download a free example and use it by replacing the dummy data with your own data.
In this article I present a model for monitoring the time spent at office by employees, check-ins and check-outs. I used Excel array formulas (max, min, small) with multiple conditions and also other formulas.