i have an advanced filter that i want to display unique values, but due to
cells being added later on, i have the filter on more cells than contents at
the moment, but its taking a blank cell as a unique value, which i dont want.

can you add an excpetion so that the cell must contain data or not empty to
then be filtered? i have looked on this website but found nothing -
http://office.microsoft.com/en-us/as...001781033.aspx

if not, is there another way to do this?

thanks

Jamie