multi column address data base i would like to break down

[lockwood]

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

 

[oldbrewer]

not clear........show us 5 rows of data

 

[lockwood]

thanks for being there, i appreciate the help

name	address 1	city	state	zip	contact	contact title	peptalk P=Yes	cust	notes
SITEWORKS, INC	6000 WEST GENESEE ST	CAMILLUS	NY	13031	ANDREW AUPPERLE	PRESIDENT	p	29309	p 29309
VACRI CONSTRUCTION CORP.	1 BRICK AVENUE	BINGHAMTON	NY	13901	ANDREW AUPPERLE	PRESIDENT	P	25117	P 25117
CITY OF NORWICH, NY	1 CITY PLAZA	NORWICH	NY	13815	ANDREW AUPPERLE	PRESIDENT	P	8265	P 8265
VILLAGE OF SOUTH CORNING	1 CLARK STREET	CORNING	NY	14830	ANDREW AUPPERLE	PRESIDENT	P	7956	P 7956
SENECA CTY. WTR & SWR DISTRICT	1 DIPRONIO DRIVE	WATERLOO	NY	14588	ANDREW AUPPERLE	PRESIDENT	P	26345	P 26345
TOWN OF CAPE VINCENT, NY	1 MARKET STREET	CAPE VINCENT	NY	13618	ANDREW AUPPERLE	PRESIDENT	P	12085	P 12085
CITY OF CORNING DEPT. OF PUBLIC WORKS	10 CIVIC CENTER PLAZA	CORNING	NY	14830	ANDREW AUPPERLE	PRESIDENT	P	8182	P 8182

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[oldbrewer]

ok, what is a county group ? do you want all the CORNINGS to be together ? You can sort by up to 3 columns eg first by state second by city etc etc

once we define what is wanted Fluff will sort it (sry Fluff)