Hello,
I am trying to compare the numbers in e82:i83 to numbers in e109:n110 and count the number of matches with the total to show in another cell, n82. I am running windows XP and Excel 97. It seems simple to me but I have tried everything I know and have read with no satisfactory results. Any help is appreciated.
3542
Configuration: Windows XP Internet Explorer 8.0
I wonder whether your ranges are correct. The two 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 |
3 columns change data if it match vba excel Compare 2 excel columns Count days in excel Count matches in different columns Count number of columns matching 2 criteria Date format in excel column data Excel columns copy vb.net Excel count unique values if column b has 1 Find matches in excel columns Get count of last valued column in excel sheet using macro How to change background color in excel column using value How to check if 2 excel files are the same How to find matches in excel columns How to repeat numbers in excel columns Macro excel columns Match 2 columns and append 3rd column values in excel Match excel columns and add data to column Vba count items in a column