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!
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.
Hi,
Where do you want the word 'Paid to appear?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
missing a bitOriginally Posted by mikerickson
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
what happens if an invoice is added a third time? in the current format it will mark paid. is this correct
Thank you so much - That is just what I needed!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks