Thanks for your help Ron. Yeah unfortunately I am unable to use a filter function for the particular spreadsheet I am using. But the formula was exactly what I was after. Thanks again.