+ Reply to Thread
Results 1 to 6 of 6

If duplicate entry in column - mark as paid

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    NS
    MS-Off Ver
    Excel 2007
    Posts
    2

    If duplicate entry in column - mark as paid

    I have a list of invoices that have been paid in column A. When I receive new invoices I would like to add them to column A and if the value already exists anywhere in column A then the new entry would be marked as "paid" otherwise it would be "to be paid".

    Can anyone offer help writing a formula?

    Thanks!

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,206

    Re: If duplicate entry in column - mark as paid

    If you have invoices in column A, you might put =IF(COUNTIF(A:A, A1),"Paid", "not paid") in B1 and drag down
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,443

    Re: If duplicate entry in column - mark as paid

    Hi,

    Where do you want the word 'Paid to appear?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: If duplicate entry in column - mark as paid

    Quote Originally Posted by mikerickson View Post
    If you have invoices in column A, you might put =IF(COUNTIF(A:A, A1),"Paid", "not paid") in B1 and drag down
    missing a bit

    you could do that with this

    Please Login or Register  to view this content.
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  5. #5
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: If duplicate entry in column - mark as paid

    what happens if an invoice is added a third time? in the current format it will mark paid. is this correct

  6. #6
    Registered User
    Join Date
    09-12-2012
    Location
    NS
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: If duplicate entry in column - mark as paid

    Thank you so much - That is just what I needed!!

+ 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