I need a macro that will go line by line and find any lines that share the same info in column A and column C. I need the search to exclude zeros for column C and only find duplicates of values "1" through "9". The only exception to this is "if" the zero is after a higher value. ex. if value is: 00120, exclude first two zeros from search. Also, it would need to search alpha-numerically. Ex. A0190 and A190 would be considered duplicate. I have some excel sheets with 60,000 lines of information and I would like for it to find the duplicates and automatically put them into a new sheet for analysis. I would greatly appreciate any help with this that you can provide.
|column A||column B||column C, etc|