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 |
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 . |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com