View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Toney Toney is offline
external usenet poster
 
Posts: 18
Default Marking duplicate entries based on multiple columns

Hi all,

I have a list of files that I'd like to mark the duplicates. I can't use
just the file name because some files have the same name but aren't the same
file. As I understand it COUNTIF can't be used with multiple comparisons.
I've tried CONCATENATE several of the columns and then using COUNTIF but it
doesn't seem to work.

Example of what I'm looking for....

File A, 400k, 9/23/09, Duplicate
File A, 450k, 9/23/09
File A, 400k, 9/23/09, Duplicate

Thanks in advance
Toney