View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Find Duplicates and Move to New Worksheet

Did you change the criteria formula in A2 like I mentioned in my response,

Just replace the criteria formula in A2 with:
=IF(B!A2="","",IF(ISNUMBER(MATCH(B!A2,A!A:A,0)),RO W(),""))
then copy down


It should work fine. Try it again.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Adurr" wrote:
OK I downloaded your spreadsheet and it was great, I was able to find
unmatched entries, I changed your formula to find matched entries like so:

=IF(ROW(A1)COUNT($A:$A),INDEX(SonySI!A:A,SMALL($A :$A,ROW(A1))),"")

Everything comes up blank, I have missed something, I just don't know what.