| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Data in Excel
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Grouping Data in Excel
Use the Auto Filter or Advanced Filter.
"Fran B" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
