Results 1 to 11 of 11

Add Unique Records

Threaded View

kashifshahzad Add Unique Records 07-25-2016, 07:57 AM
AliGW Re: Add Unique Records 07-25-2016, 08:01 AM
kashifshahzad Re: Add Unique Records 07-25-2016, 08:07 AM
AliGW Re: Add Unique Records 07-25-2016, 08:08 AM
oeldere Re: Add Unique Records 07-25-2016, 08:08 AM
kashifshahzad Re: Add Unique Records 07-25-2016, 08:13 AM
oeldere Re: Add Unique Records 07-25-2016, 08:17 AM
kashifshahzad Re: Add Unique Records 07-25-2016, 08:21 AM
AliGW Re: Add Unique Records 07-25-2016, 08:25 AM
kashifshahzad Re: Add Unique Records 07-25-2016, 08:29 AM
AliGW Re: Add Unique Records 07-25-2016, 08:33 AM
  1. #1
    Registered User
    Join Date
    05-14-2014
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    46

    Add Unique Records

    I have two columns A & B in sheet name and points. there are multiple names with their points entered. in same sheet i have another two columns M & N name(Named entered unique), i want to add the points entered in col. B. i used formula
    =COUNT(INDEX(B2:B222,MATCH(M2,A2:A222)))

    but it gives wrong result. could some one please help out.. thanks
    see the attached file for reference.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 04-30-2013, 07:42 PM
  2. [SOLVED] Comparing records to result in a list of unique records
    By greenmat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 07:45 PM
  3. Unique values and Unique Records
    By rjbautista20 in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2012, 05:12 AM
  4. Filter unique records only: Want the last records, not the first
    By davelarue in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-11-2009, 08:51 AM
  5. Unique records
    By geomcleod in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2008, 02:08 PM
  6. unique filter results in some non-unique records.
    By Serials Librarian in forum Excel General
    Replies: 2
    Last Post: 05-26-2006, 05:10 PM
  7. Unique Records
    By Happy in forum Excel General
    Replies: 9
    Last Post: 07-27-2005, 10:05 AM
  8. Unique records
    By Pete in forum Excel General
    Replies: 1
    Last Post: 07-26-2005, 02:05 PM

Tags for this Thread

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