Shulou(Shulou.com)11/24 Report--

Today, I would like to share with you ten function formulas commonly used in the workplace, which can improve the efficiency of our daily work.

1. Statistics on the number of repetitions how to quickly count the number of repetitions of content in a column of cells.

= COUNTIF (Azul Amae A3)

2. Whether the statistics repeat more data in column A, how can we find out if there are any duplicates?

= IF (COUNTIF (Apura Amena A3) 1, "repeat", "do not repeat")

3. Statistics on the number of non-repetitive contents there are repetitive and non-repetitive contents in the table, but we just want to know the number of all data without repetition.

= SUMPRODUCT (1/COUNTIF (A2 A9 recorder A2VR A9))

4, statistics whether qualified IF function, greater than or equal to 8.0 is qualified, otherwise it is not qualified.

= IF (B30008, "qualified", "unqualified")

5. Statistics on the number of qualified people COUNTIF is a counting function, which can count qualified cells in the region.

= COUNTIF (C2:C10, "qualified")

6. rank from high to low by score, and show the number of rankings by data score.

= RANK (B3, and B10)

7. The DATEDIF function can return the number of years / months / days between two dates. TODAY () indicates that the current date of the system is obtained, and the age is obtained by comparing the current system date with the existing date of birth. "Y" returns the number of years. It can also be replaced with "M" is the number of months; "D" is the number of days.

= DATEDIF (B3Today (), "y")

8. The TEXT function of the week according to the date can convert the value to the content represented by the specified number format, and the "AAAA" is displayed in Chinese.

= TEXT (A3, "AAAA")

9. How to get information by name how to quickly find the employee's information through name in a personnel information table? We can do it quickly through the VLOOKUP function.

= VLOOKUP (E4PowerA2purC10Phone2Phone0)

10. Comparing different data and comparing two columns of data, how to quickly find out different and the same data?

= IF (A3=B3, "same", "different")

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.