How do I filter a list in EXCEL?

Question

I have a property information disk in EXCEL. It does not have column labels, but I know what the colums are. I need to filter for unique records, so that I don't have duplicate names and addresses on mail merge, and I need to filter the Total Acres columns to be > than or equal to 40. And keep the right information together. Thanks!

Answer 1

excel 2003 version
select all the column headers, then from the data menu, choose filter, autofilter.
with the dropdown menu in every column header, choose what address and name you want. As for the area from the dropdown menu select personalized and then "greater than or equal to" and type in 40 in the field.

Answer 2

You will find life easier if you add column headings.

In the Mailmerge Main document (letter, label, whatever) after you "Open Data File", click Query Options.

There is a tab to filter and one to sort.

click the Filter tab. Click the down arrow to display the field that represents total acres.

Next to that, you indicate the operator-- click the down arrow to select "greater than"

In the next box enter the value - which in this case, is 40.

Letters/labels will print only for those for whom the total acres are greater than 40.