I have a large multi column address data base i would like to break down into county groups by loading in lists of the individual municipalities. how do i write a reusable function/formula in excel that mimics this query? "city" contains Arkport OR Atlanta OR Avoca OR Cohocton OR Dansville OR Fremont OR Wayland OR Wheeler OR Prattsburgh OR Perkinsville OR Pulteney OR Bradford OR Hammondsport OR Urbana OR Wayne AND "state" contains “NY”
thanks lockwood
thanks lockwood