Count the matches in two excel columns
Closed
3542
-
Oct 17, 2009 at 11:11 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 18, 2009 at 08:29 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 18, 2009 at 08:29 PM
Related:
- Count the matches in two excel columns
- Number to words in excel - Guide
- Display two columns in data validation list but return only one - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 18, 2009 at 08:29 PM
Oct 18, 2009 at 08:29 PM
I wonder whether your ranges are correct. The two ranges
overlap.
any how I have given the macro. change to correct ranges.
overlap.
any how I have given the macro. change to correct ranges.
Sub test()
Dim r As Range, r1 As Range, c As Range, j As Integer
Dim cfind As Range
Range("N82").Clear
Set r = range("E82:I183")
Set r1 = range("E109:N110")
For Each c In r
Set cfind = r1.Cells.Find(what:=c.Value, lookat:=xlWhole)
If Not cfind Is Nothing Then j = j + 1
Next c
Range("N82") = j
End Sub
