Function to Find Duplicates

  • Thread starter Thread starter Rocky McKinley
  • Start date Start date
R

Rocky McKinley

Hi I'm trying to make a function which looks for duplicates. Something
like...

Function DuplicateExists (BigRange as Range, Cell as Range) As Boolean
BigRange is always in worksheet "Main"
Cell is always in worksheet "Print"
DuplicateExists = False
'something like below
If cell exists in big Range and cell <> "" then
DuplicateExists = True
End if
End Function

I tried worksheetfunction.countif but it didn't seem to want to take the
worksheetname with the range.
Ideas?

Regards, Rocky McKinley
 
countif should work just fine...

=COUNTIF(Rpint!E2:G15,Sheet1!C9)

whatever sheet you place this formula, it will return the
count of the value in sheet1C9 in the range E2:G15 on
sheet RPrint

Patrick Molloy
Microsoft Excel MVP
 
Back
Top