+ Reply to Thread
Results 1 to 2 of 2

How to loop through a column and return non duplicates?

  1. #1
    Registered User
    Join Date
    07-09-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    5

    How to loop through a column and return non duplicates?

    Looping through one column for a condition and returning non duplicate values of another column

    I’m trying to go through column A for a certain condition, and if that condition is satisfied return column B but only the non duplicates of that.
    In the very simplified example below

    2 test
    2 test
    2 test
    3 mailbox
    5 deleted

    If column A condition is “2” I just want to return a new column with one cell populated as “text”

    Can anyone here give me the right direction as to how to loop a column for a certain condition and return another’s value?

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,885

    Re: How to loop through a column and return non duplicates?

    It sound like you could get away with a simple VLOOKUP.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1