=IF(COUNTIF(A2:A2000,"CA")0,"CA","")
=IF(COUNTIF(A2:A2000,"TX")0,"TX","")

and continue downward. You will end up with fifty cells for the fifty
states, either visible (if they appeared in the big list) or blank

This works, but it is a painful substitute for using either pivots for
filters.

--
Gary''s Student
gsnu200711