Dick, I tried it again this morning after I got to work and man it worked
beautifully. I had obviously left out one of the parenthesis. You are a
true life and time saver. Thank you very much for your time and attention.


--
By persisting in your path, though you forfeit the little, you gain the
great.



"Dick Kusleika" wrote:

On Tue, 31 Mar 2009 17:32:01 -0700, DavidH56
wrote:

Thank you very much for your response Dick. I tried the formula as an array
as you said and copied down. I sorted by F and L proior to entering the
formula. I got a #REF! symbol in the last similiar cell in column M. I tried
again and got the same.

Where range is your data in? Which part of the formula is returning Ref?
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com