View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Dup entry two colums

The easiest way is to concatenate the two fields together in a new column.
Then you can use a simple count function to indicate how many of each item
that you have. Do a filter excluding 1 and you have all of your duplicates...
--
HTH...

Jim Thomlinson


"pgarcia" wrote:

Hello all,
I have two colums, one hads check number and the other has dollar amounts.
How can I find dup by first look at the check number then by dollar amount?