COUNTIF copy and pastevalue COUNTIF function can be used when calculating how many same date is exists or checking same data is no duplicated. However, this function makes your computer slow because it re-calculates every time the sheet is…

This macro filter for blanks or non-blanks by one click. I take "Split" function just I learned and array for this macro. You will see how to get the range of the AutoFilter, and this made my macro works on any Excel books

You can select cells from the the first to the end if press Ctrl + Shift + Arrow key. However, if there is a blank cell or cells are merged, you cannot reach to the end. This macro reaches the end cell even if there are hundreds of blank c…