Random Numbers Generator without Repeat Numbers using VBA in Microsoft Excel 2013

VBA Distinct Random Number Generator If you want to generate random number in Excel & all the numbers should be unique (no repeat), you can use...

How To Remove Leading or Trailing Space in Excel 2013

If you are working on importing text files & and you want to remove spaces in Excel i.e. unnecessary spaces whether they are leading spaces in Exc...

Using a Blank cell as a Criteria in Excel Sumifs

This article will use blank cell as a criteria with SUMIFS functions to calculate the Sales.   Question: I have employees’ data that contains...

SUMIFS with Dates in Excel

This tutorial explains the usage of SUMIFS functions with dates.   To quickly learn SUMIFS function; let’s understand Excel SUMIF functio...

Excel Sum Only Positive Numbers

In this article, you will learn how to sum only unique positive values in Excel.   Question: I am working on importing Excel file which con...

Create Drop Down List in Excel with Color

Original Question:- How to add drop down list with color in Microsoft Excel?   So I figured out how to create a dropdown menu in Excel. I wo...

Relative Error Formula in Microsoft Excel

In this article, we will learn how many errors in Excel formula and what is formula in Excel to ignore the error. We are having 7 types of Microsof...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube