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.
<tbody>
</tbody>
column A | column B | column C, etc | ||
row 1 |
<colgroup><col width="208"></colgroup><tbody> </tbody> | 123 | ||
row 2 | T3078 | 0123 | ||
row 3 | T3078 | 00123 |
<tbody>
</tbody>