+ Reply to Thread
Results 1 to 8 of 8

Return the first value / description of the cell under same column

  1. 11-04-2016, 04:17 AM #1
    cks1026
    cks1026 is offline
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    109

    Return the first value / description of the cell under same column

    Hi all,

    I need help.
    In column A, I've got a lot of descriptions, where there are multiple duplication
    Is there any formulae that I can use in Column B, where I can lookup the first "unique" value / descriptions from Column A, and subsequently, other duplicated value / descriptions would return as "Duplicated?

    Column A Column B
    Apple Apple
    Banana Banana
    Pineapple Pineapple
    Apple Duplicated
    Apple Duplicated
    Pineapple Duplicated
    Banana Duplicated

    Appreciated urgent help on this.

    thanks

    Regards
    cks1026
    Reply With QuoteRegister To Reply
  2. 11-04-2016, 04:33 AM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,360

    Re: Return the first value / description of the cell under same column

    One way:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 11-04-2016, 04:53 AM #3
    cks1026
    cks1026 is offline
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Return the first value / description of the cell under same column

    Quote Originally Posted by TMS View Post
    One way:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Hi TMS,

    Thanks for the quick response,
    Tried that, but somehow the first cell does not return as "APPLE", it returned as "duplicate"
    It just shows all "duplicate"...

    Please advice.

    Thanks

    Regards
    cks1026
    Reply With QuoteRegister To Reply
  4. 11-04-2016, 04:59 AM #4
    DannyJ
    DannyJ is offline
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Slough
    MS-Off Ver
    Excel 2007
    Posts
    469

    Re: Return the first value / description of the cell under same column

    It has worked fine for me. Does the data start in A1? or lower down?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 11-04-2016, 05:17 AM #5
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,360

    Re: Return the first value / description of the cell under same column

    Do you have the dollar sign in front of the first 1?
    Reply With QuoteRegister To Reply
  6. 11-04-2016, 05:31 AM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Return the first value / description of the cell under same column

    Here's another one...

    Data Range
    A
    B
    1
    2
    Apple
    Apple
    3
    Banana
    Banana
    4
    Pineapple
    Pineapple
    5
    Apple
    Duplicate
    6
    Apple
    Duplicate
    7
    Pineapple
    Duplicate
    8
    Banana
    Duplicate
    9


    This formula entered in B2 and copied down:

    =IF(MATCH(A2,A:A,0)=ROW(),A2,"Duplicate")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  7. 03-08-2017, 10:24 PM #7
    cks1026
    cks1026 is offline
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Return the first value / description of the cell under same column

    Thanks all...
    Reply With QuoteRegister To Reply
  8. 03-09-2017, 11:10 AM #8
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Return the first value / description of the cell under same column

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Macro to search a cell description and return a date
    By kevthomas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2015, 12:25 PM
  2. return the FIRST 'color' in a product description string that exists in a list of colors
    By mateo561 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-22-2015, 03:51 PM
  3. return the FIRST 'color' in a product description string that exists in a list of colors
    By mateo561 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2015, 12:36 PM
  4. [SOLVED] Match Description - Macro stops if a cell in column is blank
    By geliedee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2015, 01:24 AM
  5. [SOLVED] if a cell contains codes listed i a column it will show its equivalent description
    By miskulet in forum Excel General
    Replies: 7
    Last Post: 04-11-2013, 09:00 PM
  6. [SOLVED] Looking up description and return data
    By JakeMann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2012, 10:57 AM
  7. Compare description to a set of keyword lists and return a 3 value
    By smschneid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2012, 03:28 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