Advertisement
Advertisement
| 03.11.2008 at 06:20AM PDT, ID: 23231570 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
|
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
| Microsoft |
| Apple |
| Internet |
| Gamers |
| Digital Living |
| Virus & Spyware |
| Hardware |
| Software |
| ITPro |
| Developer |
| Storage |
| OS |
| Database |
| Security |
| Programming |
| Web Development |
| Networking |
| Other |
| Community Support |
| 03.11.2008 at 06:50AM PDT, ID: 21095671 |
| 03.11.2008 at 07:02AM PDT, ID: 21095781 |
| 03.11.2008 at 07:09AM PDT, ID: 21095824 |
| 03.11.2008 at 07:19AM PDT, ID: 21095912 |
| 03.11.2008 at 07:36AM PDT, ID: 21096086 |
| 03.11.2008 at 07:54AM PDT, ID: 21096270 |
| 03.11.2008 at 08:40AM PDT, ID: 21096790 |
| 03.11.2008 at 12:11PM PDT, ID: 21098971 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: |
Option Explicit
Option Compare Text
Sub FindCommonWords()
Dim strDWords() As String
Dim strEWords() As String
Dim sh As Worksheet
Set sh = ActiveSheet
Dim r As Integer
Dim d As Integer
Dim e As Integer
r = 1
Do Until sh.Cells(r, 4) = ""
strDWords = Split(sh.Cells(r, 4), " ")
strEWords = Split(sh.Cells(r, 5), " ")
For d = 0 To UBound(strDWords)
For e = 0 To UBound(strEWords)
If strDWords(d) = strEWords(e) Then
sh.Cells(r, 6) = Trim$(sh.Cells(r, 6) & " " & strDWords(d))
End If
Next e
Next d
r = r + 1
Loop
End Sub
|
| 03.11.2008 at 11:21PM PDT, ID: 21103479 |
| 03.12.2008 at 01:00AM PDT, ID: 21103819 |
| 03.12.2008 at 02:12AM PDT, ID: 21104075 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: |
Option Explicit
Option Compare Text
Sub FindCommonWords()
Dim strDWords() As String
Dim strEWords() As String
Dim sh As Worksheet
Dim iDWords As Integer
Dim iEWords As Integer
Dim lDRow As Integer
Dim lERow As Integer
Dim lFRow As Integer
Dim bFound As Boolean
Set sh = ActiveSheet
lDRow = 1
Do Until sh.Cells(lDRow, 4) = ""
strDWords = Split(sh.Cells(lDRow, 4), " ")
For iDWords = 0 To UBound(strDWords)
lERow = 1
Do Until sh.Cells(lERow, 4) = ""
strEWords = Split(sh.Cells(lERow, 5), " ")
For iEWords = 0 To UBound(strEWords)
If strDWords(iDWords) = strEWords(iEWords) Then
lFRow = 1
Do Until sh.Cells(lFRow, 6) = ""
If sh.Cells(lFRow, 6) = strDWords(iDWords) Then
Exit Do
End If
lFRow = lFRow + 1
Loop
sh.Cells(lFRow, 6) = strDWords(iDWords)
Debug.Print sh.Cells(lFRow, 6), lFRow
End If
Next iEWords
lERow = lERow + 1
Loop
Next iDWords
lDRow = lDRow + 1
Loop
End Sub
|
| 03.12.2008 at 02:46AM PDT, ID: 21104217 |
| 03.12.2008 at 04:07AM PDT, ID: 21104638 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: |
Option Explicit
Option Compare Text
Sub FindCommonWords()
Dim strDWords() As String
Dim strEWords() As String
Dim strFWords() As String
Dim sh As Worksheet
Dim iDWords As Integer
Dim iEWords As Integer
Dim iFWords As Integer
Dim iFWordCount As Integer
Dim lDCol As Long
Dim lECol As Long
Dim bFound As Boolean
Set sh = ActiveSheet
lDCol = 1
Do Until sh.Cells(lDCol, 4) = ""
strDWords = Split(sh.Cells(lDCol, 4), " ")
For iDWords = 0 To UBound(strDWords)
lECol = 1
Do Until sh.Cells(lECol, 4) = ""
strEWords = Split(sh.Cells(lECol, 5), " ")
For iEWords = 0 To UBound(strEWords)
If strDWords(iDWords) = strEWords(iEWords) Then
If sh.Cells(lECol, 6) <> "" Then
strFWords = Split(sh.Cells(lECol, 6), " ")
iFWordCount = UBound(strFWords)
bFound = False
For iFWords = 0 To iFWordCount
If strFWords(iFWords) = strDWords(iDWords) Then
bFound = True
Exit For
End If
Next iFWords
If Not bFound Then
ReDim Preserve strFWords(iFWordCount + 1)
strFWords(iFWordCount + 1) = strDWords(iDWords)
sh.Cells(lECol, 6) = Join(strFWords, " ")
End If
Else
sh.Cells(lECol, 6) = strDWords(iDWords)
End If
End If
Next iEWords
lECol = lECol + 1
Loop
Next iDWords
lDCol = lDCol + 1
Loop
End Sub
|
