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

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.