Merge the same Criteria cell data

Source: Internet
Author: User

The author of the unit this year has implemented the National Computer Application grade examination, according to the promotion job level different, examinee may choose 2 to 4 modules examination. Each examinee has the unique file number, the same examination qualified 1 and above module, obtains 1 Qualifications certificate, the certificate marking examinee qualified module.

If the candidate Liu XX qualified 1, there are 1 certificate, the examinee Wang xx qualified 3 families, also obtained a Certificate of conformity, certificate showed the Qualified 3 modules (Figure 1). In order to facilitate inquiries and to facilitate candidates to receive the card signature, the same file number of candidates in Figure 1 of the qualified modules to be merged, the module with "/" separated (Figure 2), then how to achieve this effect? Because the same file number has 2, 3, and 4 three cases, the number of modules to be merged is not fixed, and an array formula is needed to resolve such problems.

Figure 1 Three modules of the same file number in an Excel table

Figure 2 Merging excle the same file

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.