:Personnel administration skills ID card function skills Extracting place of origin information-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Personnel administration skills ID card function skills Extracting place of origin information

Personnel administration skills ID card function skills Extracting place of origin information

Author: daogeziyuan • • Table skills • Views 890
  • Picture and text skills


In order to facilitate the management of employees, HR needs to establish a personnel database.

Let’s teach you how to automatically extract the household registration location information from the ID card.

The software version information used in this issue is WPS Personal Edition 8919-rc.

地区.png


教程分界线.png


￭First we need to create a new ID card area code table, such as this "First Six Digits of ID Number".

Place the cursor at D2.

In the public notice column, enter =VLOOKUP(VALUE(LEFT(B2,6)), the first six digits of the ID number!A:B,2,0)

"LEFT(B2,6)" means to extract the first six digits of the ID card.

"VALUE(LEFT(B2,6))" means to convert the first six characters into numeric format.

Then use the VLOOKUP function to find the corresponding data with a column number of 2 in column A and column B from the "First Six Digits of ID Card" table.

Finally, you can fill in 1 or 0, 1 is a fuzzy search, and 0 is a precise search.

In this way, the regional information of the ID card can be quickly extracted.


1.gif


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/ren-shi-xing-zheng-ji-qiao-shen-fen-zheng-han-shu-ji-qiao-ti-qu-ji-guan-xin-xi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 刘国庆 Columnist
48 196
single-end

Related Suggestion