Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to Find Duplicates
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Duplicates | Excel Discussion (Misc queries) | |||
Find Duplicates | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) | |||
Find Duplicates | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |