Need Formula to detect duplicate invoices

  • Thread starter Thread starter XYZ via OfficeKB.com
  • Start date Start date
X

XYZ via OfficeKB.com

I need a help with formula to detect duplicate invoices (payments) listed in
my column I2 through I8317. In a separate column (next to it) I want the
computer to return information either by indicating "duplicate" or giving me
number of counts for particular invoice. The formula I tried was:
=COUNTIF(Invoice Number!$I$2:$I$8317,)I2

but it doesn't work and shows value error.

Tx.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

locating duplicates 4
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
select a range in a column 4
Duplicates 2
Formula for Avoiding totals of Duplicate Information 1
Formula Help 3
vlookup question 2
Divide One Amount for Duplicates 1

Back
Top