Thanks Joe. I did know about making that substitution but must have messed it up due to being in a hurry. I just did it more carefully and all you formulas worked perfectly with data in column A . Thanks, Steve