Formula to FIND DUPLICATE DEBIT AND CREDITS

G

Guest

I am trying to make a bank reconciliation template. I need to know the
amounts in a column that are duplicates. The duplicates may be a "credit"
amount or a "debit" amount in the same column. I would like to mark them both
as duplicates.
I would like to see for example:
A B
1234.00 duplicate
2345.00
3456.00 duplicate
4567.00
-1234.00 duplicate
-3456.00 duplicate

Thanks!
 
G

Guest

Thank you very much. Is there also something that could be added so that
"blank" cells would not have the "duplicate" printed?
 

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

Augmenting an integer in a column to reflect duplicates in another 23
Add values of data that might have duplicate labels 5
Duplicate Function Help 1
Match duplicate data in 2 columns in a worksheet 16
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
Pls help with Excel Function 1
finding duplicate addresses across 2 worksheets in the same workbo 2
Excel Excel Formula to covert a credit amount to a debit amount 1

Top