Results 1 to 2 of 2

Thread: Group Data From Multiple In To Single Cell Based On Criteria Seperated By Delimiter

  1. 08-22-2013, 02:12 PM #1
    devpp
    devpp is offline
    Junior Member
    Join Date
    Aug 2013
    Posts
    9
    Rep Power
    0

    Group Data From Multiple In To Single Cell Based On Criteria Seperated By Delimiter

    I have data like this 1.JPG
    Emp ID,Defaulters,Email ID,Date not filed,Status.
    for the same employee there are different dates not filed.My requirement is like this 2.JPG
    I want all the different dates to come in one cell separated by commas and also the other rows with the same employee name and ID to get deleted...
    Thanks ....
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 08-23-2013, 05:19 AM #2
    alansidman
    alansidman is offline
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    Look at this link:

    http://www.excelfox.com/forum/f12/vl...iple-values-4/


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9iHOYYpaAbC
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgxuL6YCUckeUIh9hoh4AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwGTEyefOX7msIh1wZ4AaABAg. 9h4sd6Vs4qE9h7G-bVm8_-
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=Ugw3nF0C04AGt73H1BB4AaABAg. 9h6VhNCM-DZ9h7EqbG23kg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwGTEyefOX7msIh1wZ4AaABAg. 9h4sd6Vs4qE9h7KvJXmK8o
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=Ugw3nF0C04AGt73H1BB4AaABAg. 9h6VhNCM-DZ9h7E1gwg4Aq
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgywFtBEpkHDuK55r214AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg. 9h5lFRmix1R9h79hNGvJbu
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg. 9h5lFRmix1R9h79YAfa24T
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg. 9h5lFRmix1R9h79M1SYH1E
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg. 9h5lFRmix1R9h78SxhXTnR
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 07-09-2023 at 11:11 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
    By valesilver in forum Excel Help
    Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  2. Split Row Data In To Multiple Columns Based On Delimiter
    By cjjn in forum Excel Help
    Replies: 2
    Last Post: 03-05-2013, 07:34 AM
  3. Best way to cross populate multiple arrays based on data entry into a single array?
    By Orestees in forum Excel Help
    Replies: 14
    Last Post: 01-26-2013, 04:58 AM
  4. Concatenate Multiple Lookup Values in Single Cell
    By Admin in forum Download Center
    Replies: 4
    Last Post: 04-06-2012, 09:07 PM
  5. Fetch Data from multiple sheets based on criteria VBA
    By Raj Kumar in forum Excel Help
    Replies: 7
    Last Post: 03-06-2012, 07:49 AM

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