Tuesday, August 10, 2010

The use of EXCEL functions of several chi hair straighteners

eHR system to do this time, all day tossing excel table, there are several useful functions,chi hair straighteners, or write down notes.


1. VLOOKUP (lookup value,uggs outlet store, lookup range,cheap ugg boots, return the scope of the first few columns,uggs outlet, 0)







Applications: Look through a column of data to another column of data, such as staff numbers to find date of birth
; Note Look at the options,ugg outlet, find the value of the column must be placed on the scope of which the first column

2. COUNTIF (Look, look for value)

This function is actually a calculated value in a column the number of occurrences.





applications: access to a given column have duplicate values, such as the duplication of staff numbers



3. EXACT (data A,cheap uggs, data B)


applications: more than 2 data is not the same, when the return is TRUE,ugg boots store, the same
Note that when two different formats of data when the result returned is FALSE


相关的主题文章:

No comments:

Post a Comment