Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why 65 to 71?
I also did not understand the line "If Range(Chr(x) & i).Text = v Then" llama wrote: Maxi This should solve your problem, strValString is your string of numbers ("1,2,3,4") Function FindFreq(strValString As String) Dim iFreq As Integer Dim iCount As Integer For i = 1 To 5 For x = 65 To 71 For Each v In Split(strValString, ",") If Range(Chr(x) & i).Text = v Then iCount = iCount + 1 End If Next Next If iCount 2 Then iFreq = iFreq + 1 End If iCount = 0 Next Debug.Print iFreq End Function Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using excel to pick data from a list, reporting names and integers | Excel Discussion (Misc queries) | |||
Macro to find text string in a column and paste data in another | Excel Discussion (Misc queries) | |||
Extracting integers from a text string. | Excel Worksheet Functions | |||
Find Data in a String | Excel Programming | |||
Wish to parse through a text string to find data | Excel Programming |