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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to Find Duplicates
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 -----Original Message----- 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 . |
Reply |
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) |