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

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

 

[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)