+ Reply to Thread
Results 1 to 2 of 2

Need a formula to find duplicate claims on a report

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    long beach,ca
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need a formula to find duplicate claims on a report

    I NEED TO PUT A FORMULA THAT WILL CATCH DUPLICATE DEALER CODES
    SO THAT I WONT BILL THEM MORE THAT ONCE.
    THE DEALER CODE IS A 4 DIGIT

    CAN SOMEONE HELP WITH A FORMULA I CAN USE.

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Need a formula to find duplicate claims on a report

    Assuming that your codes are in column A, then in column B you could have
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

+ 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. [SOLVED] Find and Tag duplicate formula
    By albert28 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2014, 10:33 PM
  2. [SOLVED] Formula to Find, Match & Highlight a duplicate cell in C.F.
    By alan_stephen75@ in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-11-2013, 07:09 AM
  3. [SOLVED] nested if formula claims there are too many arguments
    By asthx in forum Excel General
    Replies: 3
    Last Post: 02-11-2013, 01:49 AM
  4. Formula assistance - find duplicate and present results
    By craighaylett in forum Excel General
    Replies: 3
    Last Post: 10-01-2010, 06:34 AM
  5. Replies: 1
    Last Post: 12-02-2005, 05:15 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