Louise
I've put together a user defined function for you which I hope does
what you want (please let me know directly if it doesn't).
Please look at the attachment. You'll find the code for the UDF on the
module1 sheet.
+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4823 |
+-------------------------------------------------------------------+
--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=546799