Posted to microsoft.public.excel.worksheet.functions
|
|
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.
|