Results 1 to 4 of 4

Thread: Return a value within a range

  1. #1
    Acolyte Joecam's Avatar
    Join Date
    May 2014
    Posts
    34
    Articles
    0
    Excel Version
    365

    Return a value within a range



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a spreadsheet with a data dump that lists contact IDs and tags for each contact ID. The tags represent the caller, the type of call & the state of the call.

    Each contact ID should have 3 tags and currently each tag appears on a separate row while duplicating the contact ID.

    I've extracted a list of unique contact IDs to a separate list. Now what I'm trying to do is get each type of tag (Caller, type & state) into a separate column by matching to the contact ID. I've created a table that identifies the tags that belong into each category, but how can I populate the column?

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,755
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Seeing a sheet ( no pics) would help...
    Thank you Ken for this secure forum.

  3. #3
    Acolyte Joecam's Avatar
    Join Date
    May 2014
    Posts
    34
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by Pecoflyer View Post
    Seeing a sheet ( no pics) would help...
    Here you go. Thank you.
    Attached Files Attached Files

  4. #4
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    41
    Articles
    0
    Excel Version
    2016
    Sheet 2
    C2=INDEX(Sheet1!$D:$D,SMALL(IF(Sheet1!$B$1:$B$999=$A2,ROW(Sheet1!$A$1:$A$999),"/"),COLUMN(A1))) "control+shift+enter" then copy to right and down

    if you see "#num" , that means ID in column A is not shown in column B of Sheet 1 for 3 times.

Tags for this Thread

Posting Permissions

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