CLR Wrote:
No problem BEEJAY, I'm just glad you got something workinhg for you. As
you
know, there are usually several ways to do something in Excel, and the
"best"
way is the one that the user feels most comfortable with. (and not
necessarily the one that's the technical "best")..... And, sometimes,
by
getting multiple responses to the same question, we see answers to
problems
we didn't even know we had.....or something that will help us with the
next
version of whatever we're doing. All in all, these newsgroups are a
wonderful place to come........I help whenever I can, but I'm right
back here
when I have a problem also. Keep coming back, and thanks for the
feedback.


Vaya con Dios,
Chuck, CABGx3


I couldn't agree more. I have learn so much helping others. I find
that people are ususally comfortable with a handful of function and we
tend to try and solve all problems with these functions. I am a big
(often bullheadedly) fan of nested if statement. But I am learning
from many examples that lookup is a much "cleaner" approach most of the
time.

Thanks CLR


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554604