In this article, I will tell you how to remove duplicate rows in excel with two methods. The first method is using the excel advanced filter feature, this method can reserve the original datasets. The second method is to use excel’s remove duplicates menu, this method will remove the duplicate rows permanently.
This article will tell you how to use the VBA sub-procedure to catch the worksheet change event and then insert the current date time in the next adjacent cell. It will also tell you how to use VBA to create an excel function and call the function to insert the current date and time in …
How To Use VBA To Insert Current Date Time In Excel Read More »
When you input a formula in an excel cell, sometimes you may encounter the excel circular reference error. The error message is there are one or more circular references where a formula refers to its own cell either directly or indirectly. This article will tell you how to fix this error on Excel for Windows …
