software

I am working with a mail list which includes real estate information such as
sale price, assessed value. I need to select certain propertys with a sale
price of over $300K and an assessed value over $200K. I presently highlight
the properties that meet my criteria, then cut and paste to group the
highlighted data together. Any way the highlighted data can be grouped
together without the cutting and pasting, which can take a long time. My
list is over 60,000 names.

Use the Auto Filter or Advanced Filter.

quot;Fran Bquot; wrote:

gt; I am working with a mail list which includes real estate information such as
gt; sale price, assessed value. I need to select certain propertys with a sale
gt; price of over $300K and an assessed value over $200K. I presently highlight
gt; the properties that meet my criteria, then cut and paste to group the
gt; highlighted data together. Any way the highlighted data can be grouped
gt; together without the cutting and pasting, which can take a long time. My
gt; list is over 60,000 names.