Results 1 to 2 of 2

How to combine cells together by match seperated by comma

Threaded View

  1. 06-05-2019, 01:10 AM #1
    rajamdade
    rajamdade is offline
    Registered User
    Join Date
    06-21-2014
    Location
    India
    MS-Off Ver
    MS Excel 2016
    Posts
    34

    Lightbulb How to combine cells together by match seperated by comma

    Kindly help me to get result as in column D and E, when given data as in column A and B

    A B C D E
    Species list Species group Group name Combine groups
    A001|Species_1 Species_1 Species_1 A001|Species_1,A002|Species_1,A007|Species_1
    A002|Species_1 Species_1 Species_2 A004|Species_2,A008|Species_2,A005|Species_2
    A007|Species_1 Species_1 Species_3 A003|Species_3,A009|Species_3,A013|Species_3
    A004|Species_2 Species_2
    A008|Species_2 Species_2
    A005|Species_2 Species_2
    A003|Species_3 Species_3
    A009|Species_3 Species_3
    A013|Species_3 Species_3

    Thanks in advance!
    Last edited by rajamdade; 06-05-2019 at 02:29 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Use INDEX and MATCH to return values from 2 other cells
    By nestlerja in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2019, 12:07 PM
  2. [SOLVED] INDEX MATCH Lookup and Combine/Add Multiple Values
    By timmckean in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2017, 09:47 AM
  3. Index/Match if Indexed is greater than 7 or Sumproduct/Mod/Column (?)
    By Franky alta in forum Excel General
    Replies: 1
    Last Post: 09-25-2016, 02:58 AM
  4. [SOLVED] Index un-indexed items keeping original index numbers where they exist
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-25-2016, 03:55 AM
  5. link cells from different worksheets in order to populate indexed values
    By opusarlo in forum Excel General
    Replies: 4
    Last Post: 02-15-2015, 09:27 AM
  6. index match minimum 2 matches or more with a single formula , maybe using indexed value as
    By polease in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2014, 11:00 PM
  7. [SOLVED] COUNTA for Indexed cells without solving for the index
    By ScottBeatty in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-25-2013, 04:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1