Hi that looks good but I'm struggling on the criteria, if column D is the column that potential will have the Y in it, how do you write that as the criteria.


Thanks again I can think of many other things I should have used advanced filter for