MrExcel
.
- Joined
- Feb 8, 2002
- Messages
- 3,414
- Office Version
- 365
- Platform
- Windows
The April 2003 challenge is up at http://www.mrexcel.com/challenge.shtml
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Best General Add-In Challenge
- Thread starter MrExcel
- Start date
Excel Facts
Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
.. It seams that MrExcel's Team have a lot off work ...
.. I think that "challenge of the month" is an interesting part of the Forum
and the Team must Do something about this to make it What it's Name Says "challenge of the month" not "challenge of the Year" ...
.. I think that "challenge of the month" is an interesting part of the Forum
and the Team must Do something about this to make it What it's Name Says "challenge of the month" not "challenge of the Year" ...
Todd Bardoni
Well-known Member
- Joined
- Aug 29, 2002
- Messages
- 3,042
IOANNIS said:.. It seams that MrExcel's Team have a lot off work ...
.. I think that "challenge of the month" is an interesting part of the Forum
and the Team must Do something about this to make it What it's Name Says "challenge of the month" not "challenge of the Year" ...
Hey, hey, hey...relax...they don't have to do anything at all. So, let's just appreciate what they do...
And no one better call be a brown-noser! Otherwise...
DreamAlchemist
Board Regular
- Joined
- Dec 18, 2002
- Messages
- 96
ok I tried using that formula to swap the two words and although works with the add in, not if entered just as a formula, I had to rewrite the formula to..
=CONCATENATE(RIGHT(A1,LEN(A1)-SEARCH(", ",A1)-1)," ",LEFT(A1,SEARCH(", ",A1)-1))
to get it to work as just a formula (supstituting the @ for a1)
My question is why doe s the formula require concantenate and not the add in?
=CONCATENATE(RIGHT(A1,LEN(A1)-SEARCH(", ",A1)-1)," ",LEFT(A1,SEARCH(", ",A1)-1))
to get it to work as just a formula (supstituting the @ for a1)
My question is why doe s the formula require concantenate and not the add in?
Sourdust
Well-known Member
- Joined
- Sep 15, 2002
- Messages
- 769
tbardoni said:Hey, hey, hey...relax...they don't have to do anything at all. So, let's just appreciate what they do...
And no one better call be a brown-noser! Otherwise...
The opportunity is too good to miss
YA BROWN NOSING, BOOT LICKING, *** KISSING, LOWER THAN A SNAKES BELLY CRAWLING LAPDOG
Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
Sourdust said:The opportunity is too good to miss
YA BROWN NOSING, BOOT LICKING, *** KISSING, LOWER THAN A SNAKES BELLY CRAWLING LAPDOG
Hark at Mr. "I Love Celtic".
Sourdust
Well-known Member
- Joined
- Sep 15, 2002
- Messages
- 769
Hey I never professed any Timmish inclinations, its just that I detest the bluenoses so I automatically side with anybody they don't like (that doesn't leave many ). However if you find that offensive I will try to balance my loathing between both soap dodger teams
). However if you find that offensive I will try to balance my loathing between both soap dodger teams 
Aaron Blood
Active Member
- Joined
- Oct 10, 2002
- Messages
- 485
Here's my belated entry...
Private Sub Workbook_Open()
If Not AddIns("Analysis ToolPak").Installed Then
MsgBox "You're a freakin idiot!"
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End If
End Sub
After the 100th person asked me about the #NAME? errors I had to just start including it in every workbook.
Private Sub Workbook_Open()
If Not AddIns("Analysis ToolPak").Installed Then
MsgBox "You're a freakin idiot!"
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End If
End Sub
After the 100th person asked me about the #NAME? errors I had to just start including it in every workbook.
