Results 1 to 3 of 3

Thread: Extract All Synonymous Names In A Range To Another Range Using Formula

  1. #1
    Junior Member
    Join Date
    May 2014
    Posts
    1
    Rep Power
    0

    Extract All Synonymous Names In A Range To Another Range Using Formula

    In sheet one, here is a general list but some of the Items or names are twice, I would like to find out a separate list in sheet two along with all information which are in the same rows, from those Items or names which come twice in sheet one.
    Looking for a formula, that salve the above problem,
    Thanks,
    Wafa

  2. #2
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    13
    Please post an example file which reflects your situation so we have something to work with.

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Are you implying that you need a list of all items that have synonymous names? If yes, how can the formula identify whether it is synonymous?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 8
    Last Post: 04-13-2014, 02:38 PM
  2. Transpose A Range Of Cells Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 3
    Last Post: 07-13-2013, 01:25 AM
  3. VBA Looping Input Range and Output Range
    By Whitley in forum Excel Help
    Replies: 7
    Last Post: 04-25-2013, 09:02 PM
  4. Count consecutive value in a range using formula
    By LalitPandey87 in forum Excel Help
    Replies: 6
    Last Post: 11-12-2012, 05:23 PM
  5. Extract Unique Values From a Range
    By Admin in forum Download Center
    Replies: 0
    Last Post: 05-13-2011, 10:11 PM

Posting Permissions

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