VBA Codes to Highlight Duplicate Values in Excel
While working with huge data, duplicate values are always a concern. Most of the time I use remove [...]
How to Extract Hyperlink Address (URL) in Excel Using VBA UDF
Let's say you got an Excel workbook from your colleague where you have a list of hyperlinks in [...]
How to Concatenate a Range of Cells in Excel [5 Methods]
CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells [...]
How to Count Unique Values in Excel [Formulas + VBA]
Let’s say you have a list of values where each value is entered more than once.And now... You [...]