View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
waylonk waylonk is offline
external usenet poster
 
Posts: 4
Default Locating row with no duplicate matching amount

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.