Not to mislead, however, you can use a combination of functions in an array
formula to accomplish what you want to do - but that wasn't the question.
Or use a UDF as shown by Chip.

If you need the combination of functions, repost here or ask in
worksheet.functions.

--
Regards,
Tom Ogilvy

"davidm" wrote in
message ...

Many thanks Tom.
Oftentimes, a confirmatory NO answer is a positive one! It sets the
mind at rest.


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=390579