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 …

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 …

Auto Recover file location – Recover lost Word/Excel document

The feature of AutoRecover will automatically save your working document in every specified minute, if you have enabled this feature Read More …

Copy values-formatting from a range to another (Excel)

In Excel, copy values and formatting only can do as follows: Select the range you want to copy. Click Edit Read More …

Evaluate value between numbers (Excel)

Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) Generic formula =AND(val>MIN(num1,num2),val<max (num1,num2)) Read More …