Quote Originally Posted by dandavis1
Just a thank u arthurbr, thats exactly what i need and have tested it and it now works....thanks

Glad to help and thx for the feedback
If you want to know more about these formulae have a look at http://www.cpearson.com/excel/ArrayFormulas.aspx