Favorite team:
Location:
Biography:
Interests:
Occupation:
Number of Posts:5
Registered on:8/26/2014
Online Status:Not Online

Recent Posts

Message

re: What was the last thing you fixed?

Posted by msuhunter on 5/11/16 at 7:44 am
So I had a mental lapse last night. Pulled into the carport with a spreader strapped to the top of the suburban. By some miracle the strap broke before I damaged the suburban or the roof. Only damage was I split the gutter in two. We had a nice storm rolling in last night, so across two hours, I stole a 12' section of gutter off the shop, made an endcap and a downspout and installed as the rain started. I've got to go back and seal the seam at the splice later this week after everything dries out.

TLDR - Gutter
send your email to msuhunter at yahoo . com and ill send you the file
VBA:
Function GetWords(x As Range, List As Range)
GetWords = ""
For Each y In List.Cells
If InStr(x.Text, " " + y.Text + " ") > 0 Then
If Len(GetWords) > 1 Then
GetWords = GetWords + ", "
End If
GetWords = GetWords + y.Text
End If
Next
End Function

Excel:
=GetWords(A1,$B$1:$B$5)

This doesn't account for multiple uses of the same word but could be easily modified if needed.


5 seats MSU vs Northwestern
Section 4 Row 24 Seats 5-9
Asking Face+Shipping ($150+$20) will FedEx overnight
Please include shipping address/phone #/email address in PM
Will invoice via PayPal