Excel 2003 Compare Line-By-Line (Two Columns)

xxloganxx

New Member
Joined
Dec 21, 2016
Messages
1
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.:confused:


column A column Bcolumn C, etc
row 1
T3078

<colgroup><col width="208"></colgroup><tbody>
</tbody>
123
row 2T3078
0123
row 3T3078
00123

<tbody>
</tbody>
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top