Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cleaning up spread sheets
I am working with a spread sheet that has 10 columns with info including
names, addresses, type of crops grown and acres. This column was sent to me listing each parcel, so if someone owns 10 parces with various acres for each parcel they are listed 10 times. I am trying to put this together to for a mailing list. So if we want to mail to someone who has over 75 acres and they are listed on the list 10 times with lets say 25 acres per parcel they would not be choses because the acres would show 25 not his total acres of 250. I have put the spread sheet together so that I have all the parcels together and have been using autosum to total the parcels, then make the change in the acres on one line and deleting the other 9 lines so he is only listed once with the total acres. Is there a better or easier way to do this? -- Jan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cleaning up spread sheets
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutiple Spread Sheets | Excel Worksheet Functions | |||
archiving spread sheets | Excel Discussion (Misc queries) | |||
spread sheets - adding | Excel Worksheet Functions | |||
spread sheets vlookup | Excel Worksheet Functions | |||
The history of spread sheets | Charts and Charting in Excel |