Compare two columns text
Closed
Zak
-
Jun 28, 2012 at 03:13 AM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Compare two columns text
- How to compare two columns in excel for partial matches - Guide
- Comparing two columns of names in Excel ✓ - Forum - Excel
- A variation on the compare 2 columns in Excel ✓ - Forum - Excel
- I would like to compare 2 columns. ✓ - Forum - Excel
- How to compare several columns...? ✓ - Forum - Excel
1 reply
venkat1926
Jun 28, 2012 at 06:55 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jun 28, 2012 at 06:55 AM
Sub test() Dim r As Range, filt As Range Worksheets("sheet2").Cells.Clear With Worksheets("sheet1") Set r = .Range("a1").CurrentRegion r.AutoFilter field:=1, Criteria1:="private" r.AutoFilter field:=2, Criteria1:="car" Set filt = r.Offset(1, 0).Resize(r.Rows.Count - 1).SpecialCells(12) filt.Copy With Worksheets("sheet2") .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial End With .AutoFilterMode = False End With Application.CutCopyMode = False End Sub