How to Find and Remove Duplicates in Microsoft Excel? Finding Duplicates 1. For finding the duplicates, we will be utilizing the conditional formatting function. In this example, we need to discover if any name has been frequently. So first, we will choose the Name column. 2. Press on the conditional formatting option accessible at the…
Read more
Excel ISNA Function ISNA function helps to get rid of #N/A code error Using ISNA function we can tell Excel to leave the cell blank or to display any desired text like “not found” instead of displaying #N/A code error. See how the function is used in the example: The function is =if(isna(vlookup(E4,list1,2,false)),“”,vlookup(E4,list1,2,false)) =if(isna(vlookup(E4,list1,2,false)),””,vlookup(E4,list1,2,false))<br />…
Read more
What is a Pivot Table? A pivot table is a data summarization device that is utilized in the context of data handling. Pivot tables are utilize to summarize, sort, rearrange, group, check, aggregate, or standard record stored in a database. It permits its clients to change columns into rows and rows into segments. It permits…
Read more
Excel Vlookup Vlookup is an advanced Excel function that helps extract values from the database. Vlookup can filter large volume of data to provide the appropriate values based on the given conditions. V lookup can be used in two ways, to find an exact match and to find the closest match. In this example, it…
Read more
Excel sumif Function The SUMIF function is used to sum up the values of some specific cells of a column, the cells which meet certain criteria. The syntax of SUMIF function is: =SUMIF(range,criteria, [sum_range]) =SUMIF(range,criteria, [sum_range])<br /> So, the SUMIF function has three main parts: Range: It refers to range of cells that you want to…
Read more
Excel Macros By using Macro we can record a task. It is very useful when you have a task that you need to perform repeatedly. It speeds up the procedure and assures accuracy. How to open a macro: Open View tab. On the right end of the Ribbon you will find the macro button. Click…
Read more
Excel Advanced If Functions =IF (AND(B3>50,C3>50),B3+C3,B3*C3) The IF function says if values of both cells B3 and C3 are greater than 50 then add these cells else multiply these cells. See the image given below. =IF(B4>AVERAGE(C4:C9),”cell B4>average”,””) The IF function says if value in cell B4 is greater than the average of the cells from…
Read more
How to use COUNT, COUNTIF, and COUNTIFS Function? Excel COUNT The COUNT function returns the absolute number of cells that include numbers. This count contains both Numbers and Dates. Syntax COUNT (value1, [value2]…) COUNT (value1, [value2]…)<br /><br /> Where the parameters, value1, [value2], etc. can be any values or authority to cell ranges. Example 1: The following…
Read more
Excel If Function with Calculations “IF function” can be used in complex calculations. See the example: If a sales executive sells more than 5 items, the company will pay incentive 40 rupees per item sold and if the sales executive sells less than 5 items, the company will pay 20 rupees per item sold. See…
Read more
Excel If Function The IF function or IF statement in Excel is composed of three parts separated by commas. A condition What to display if the condition is fulfilled What to display if the condition is not fulfilled See how the “IF function” is created step by step to find the safe and unsafe travelling…
Read more