Locating row with no duplicate matching amount

W

Waylonk

I have a spread sheet with 4 columns and 900 rows I am trying to identify the
rows that do not contain a duplicate amount. For example I have rows with

100
100
97
97
96
96
98
101

I am trying to pull the list of 98 and 101. The spreadsheet is a list of
invoices paid vs invoices unpaid if it is paid there are two rows with the
same data if it is unpaid there is only one row. I am trying to find the
unpaid invoices.

Any help would be appreciated.
 
T

Tom Hutchins

Here is one way...

Assuming your invoice numbers are in column A, in the first free column enter
=COUNTIF(A:A,A2)
Copy it down through all rows of data. This formula counts the number of
times each invoice appears in column A.

Now apply an autofilter to the worksheet. Set it to only show records with a
value of 1 in the column you just added. The resulting visible rows are your
unmatched invoices.

To copy that list to another sheet, highlight all the filtered data. Press
F5 (Go to) and select Special >> Visible cells only >> OK. Copy & paste to
another sheet.

Hope this helps,

Hutch
 

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

Top