Excel – Remove Everything But Duplicate Rows

In Excel, we all know that, there will be a moment in which we need the opposite the people usually need on usual Excel worksheets: this is the case of searching and filtering, from a dataset, only duplicates values, removing the unique ones. Read More …

Excel – Allow Certain Users to Edit Cells Range

Excel offers you an ability to assign user-level permissions to different areas on a protected spreadsheet. You can specify which users (usually local or Active Directory ones) can edit a particular range while the spreadsheet is protected. Read More …

Not getting updates via Windows Update (Microsoft Office)

By default Windows Update only updates Windows itself. In order to get updates for Office and other Microsoft products as Read More …

Create Barcode without Third Party Software (Microsoft Excel)

A barcode is a series of lines with varying width that hold any type of information. Nowadays, barcode has been Read More …

Replace Function to replace characters in a String (VBA)

Use the VBA Replace function to replace a substring of characters in a string with a new string. VBA Replace Read More …