Find the Duplicate entries in the list using Countif formula

To find out the duplicate entries in a list, we can use the COUNTIF formula. The COUNTIF function counts the number of cells in a range which meets the given criteria. With the help of COUNTIF function we can find out how many times a given entry is appearing in the list. Syntax for COUNTIF Function: =COUNTIF(range, criteria) We will READ MORE

10 Shortcut Keys in excel to speedup your work.

The shortcut keys will speed up the work by avoiding mouse clicks. Remembering these shortcut keys may be difficult, but by regular practice we can develop the habit of using short cut keys. Following are the 10 shortcut keys to speedup your work. 1 Ctrl+Space and Shift+Space  these are the short cut keys used for selection of cell. Ctrl+Space will READ MORE

Left, Right and Len functions in excel

If you want to split the information in a cell and get only few number of characters in a particular cell you can use the simple functions like LEFT or RIGHT.LEFT: syntax for LEFT function=LEFT(text, [num_chars])LEFT function will give the number of characters given in the formula from left of the referred cell. If the number of characters is not given, READ MORE

How to use VLOOKUP in excel

VLOOKUP in excel is the popular and widely used formula in MS Excel. VLOOKUP function searches given value ( lookup_value) in the left most column of the table and returns the value in the  given column (col_index_num) of the matching row. The syntax for VLOOKUP in excel: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value: lookup_value  is the value you want to search READ MORE

SUMIFS Functions in Excel

SUMIF function is used to add the cells in a range which meets the given criteria. In SUMIF function you can give only one criteria. SUMIFS function adds the cells in a range which meets multiple criteria. Syntax for SUMIFS function is =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) The sequence of arguments are different in SUMIFS function as compare to READ MORE

How to use Excel SUMIF Formula

In this article we have explained how to use Excel SUMIF Formula. Excel SUMIF function can be used to sum the value in a range that meets the given criteria.  Syntax for Excel SUMIF Formula is:  =SUMIF(range, criteria,[sum_range]) range is the argument that specifies the cells in which the criteria or the condition is to be checked. We should select the READ MORE

Excel SUM Formula

SUM is one of the most commonly used function in Excel , which is used to add the numbers in the argument. In this article you can learn the syntax and how to use excel SUM formula. You can use this formula to add the numbers in a range by selecting a range reference in the formula.   You can READ MORE

Using the $ sign in excel formula to fix the cell reference

If you copy and paste a cell containing formula or drag the cell, the formula reference will also change and move accordingly. For example, if you want to calculate the amount of sales to each customer based on the number of units sold when the sales price is fixed, and the sales price is updated in one cell (B3), you READ MORE

Hide error value in excel formula cells.

  In Microsoft Excel, if the inputs are not valid, then the forula will show the error. This error may be like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.   To avoid this error, you can use the “ISERROR” or “IFERROR” formula. “IFERROR” is simple and easy, but this function is available only in Excel 2007 and above versions. READ MORE