+ Reply to Thread
Results 1 to 4 of 4

Formula repeats only once

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    ukraine
    MS-Off Ver
    Excel 2007
    Posts
    141

    Formula repeats only once

    Hi All,
    I'll appriciate your help by getting in table 2 values only ones (i'm doing v-lookup to sumif from table 1), per attached (without the yellow items).
    Thanks for your help,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Formula repeats only once

    Sorry, Im unsure what your desired results are? Could you explain what you're looking to get as the vlookup you have is working correctly ie its pulling back the 1st occurence of the required record.
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,362

    Re: Formula repeats only once

    Why are A & B in table 2 twice? Just remove them?

    If you want unique list in G

    in G3

    =IFERROR(INDEX($A$2:$A$8,MATCH(0,INDEX(COUNTIF($G$2:G2,$A$2:$A$8),0,0),0)),"")

    copy down

    in H3

    =IFERROR(VLOOKUP(G3,A:C,3,0),"")

  4. #4
    Forum Contributor
    Join Date
    09-05-2012
    Location
    ukraine
    MS-Off Ver
    Excel 2007
    Posts
    141

    Re: Formula repeats only once

    Thanks a lot!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for finding repeats in previous row
    By derekryans in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-21-2015, 03:23 PM
  2. Need formula to select 20 names from list of 300 with no repeats
    By Melski in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2015, 01:07 AM
  3. [SOLVED] newbie: Copying a formula that repeats every 10 cells
    By oldnich in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-02-2013, 09:31 PM
  4. newbie: Copying a formula that repeats every 10 cells
    By oldnich in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2013, 07:56 PM
  5. Replies: 6
    Last Post: 12-09-2012, 09:00 PM
  6. Formulae for: 4 most repeats,4 least repeats in a series of numbers
    By Sedge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2010, 04:56 AM
  7. Replies: 3
    Last Post: 07-04-2008, 07:42 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1