Saturday, November 23

Tag: excel formula

Mar152020 by excelhelp13No Comments
COUNTIF In Excel

COUNTIF In Excel

FORMULAS, Statistical
COUNTIF plays an vital role and as a result you get to know exactly how may times the value or specific word or number available in database (array). You can see how many times the criteria name available in under shown image and video explanation So at end you will be fully clarified that this particular terms exist this may times in a database and on that basis as a result you can figure it out and remove the unnecessary duplication entry. PARAMETER: = COUNTIF ( range , criteria ) IMPLEMENT : Select the range of your database, then select the criteria you want to find or simply type the criteria into double quote as explained in video. FORMULA : =COUNTIF(A2:A8,B2)
Read More
Mar152020 by excelhelp131 Comment
VLOOKUP In Excel

VLOOKUP In Excel

FORMULAS, Lookup & Reference
Vlookup is vertical' lookup built-in Excel function that work with array(data) that is available in excel columns. This function look-up or check the value in single column of database available in excel and returns the corresponding value from another column. The Image showing the exact example of it. PARAMETER : = VLOOKUP ( Lookup Value, Table array, Column Index, 0 or False (Exact Match) ) (more…)
Read More