:"ID Card Data Analysis: Master Gender Information Extraction Skills"-Table skills免费ppt模版下载-道格办公

"ID Card Data Analysis: Master Gender Information Extraction Skills"

In order to facilitate the management of employees, HR needs to establish a personnel database. The following is the analysis of the second-generation ID card number and how to use Excel to quickly extract gender information: 1. The second-generation resident ID card number has 18 digits in total, and the specific meanings are as follows: - The first 6 digits are the area code. - The 7th to 14th digits represent the year, month and day of birth. - The 15th to 16th digits are the code of the local police station. - The 17th digit is used to indicate gender, with an odd number for men and an even number for women. - The 18th digit is a check code, usually randomly generated by a computer to verify the correctness of the ID card. 2. Use Excel formula to extract the gender information of the ID card: Enter the following formula in the public notice column: ``` =IF(MOD(MID(B2,17,1),2)=0,"Female","Male") ` `` - `MID(B2,17,1)` means extracting 1 digit starting from the 17th digit of the ID number in cell B2. - `MOD(MID(B2,17,1),2)` means to calculate the remainder of the extracted number divided by 2. - If the remainder is 0, the formula returns "Female", indicating that the 17th digit of the ID card is an even number, that is, female; if the remainder is not 0, the formula returns "Male", indicating that the 17th digit of the ID card is an odd number, That is male. 3. Picture description: - [Gender.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/auto/1669365669-b0ee53bd3a7ad1308cbeaa87bbee27e5.png) - [Tutorial dividing line.png](https:/ /font2020.oss-cn-beijing.aliyuncs.com/wps/auto/1669365669-720d63d7aa030ad422a8ec44d6d824b3.png) - [1.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/ fac3b9bfac418fe817350d7c454dd5b2.gif) Through the above method, you can quickly batch process and extract the gender information of employees in Excel, thereby improving the efficiency of personnel management.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shen-fen-zheng-shu-ju-fen-xi-zhang-wo-xing-bie-xin-xi-ti-qu-ji-qiao.html