
msuhunter
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
TLDR - Gutter
re: Could use some Excel help... SOLVED and THANK YOU
Posted by msuhunter on 3/30/16 at 12:57 pm
send your email to msuhunter at yahoo . com and ill send you the file
re: Could use some Excel help... SOLVED and THANK YOU
Posted by msuhunter on 3/30/16 at 9:37 am
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.
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.
re: Selling 5 Tickets MSU/Northwestern Section 4 Row 24
Posted by msuhunter on 9/16/15 at 6:22 pm
SOLD :nana:
Selling 5 Tickets MSU/Northwestern Section 4 Row 24
Posted by msuhunter on 9/15/15 at 8:28 pm
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
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
Popular