If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
manipulating columns
Hi all.
I have a pivot table made up, but I need to do 5 or 6 steps for the final presentation. Basically I have different columns that are categories of Land Use Zoning for Sacramento County. I have on the left side of my table the name of various projects(The Falls, Kamilos Gates, etc...). I need to be able to figure out the acreage of the Land Use Zones for each project. I have the acreages made up for each project for each type of Land Use. For example, Kamilos gates has 2 land uses, RD1-2(Residential Density 1-2 units/acre), RD2-5(Residential Density 2-5 units/acre). Now, these numbers have to be mulitplied by a preset number (made up the by the County Planning dept.) For the RD1-2 column the mulitplier is .66, to get a "Dwelling Unit Count". So how do I make up a new column that will contain the product? I know this is complex, but any ideas would be helpful. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
EXCEL should let me establish unlimited numbers of columns. | DAISY | General Discussion | 8 | February 15th, 2006 04:35 PM |
Hiding columns in report | Ace9x | Setting Up & Running Reports | 2 | February 7th, 2006 09:08 AM |
adding three consecutive columns | Darin Gibson | Worksheet Functions | 1 | November 22nd, 2005 08:50 PM |
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | foofoo | General Discussion | 1 | April 2nd, 2005 12:02 AM |
Menu Bar Security and UNHIDING columns | AccessNana | General Discussion | 1 | August 29th, 2004 02:33 PM |