Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude a column from a table calculation
Hi,
Is there a way to exclude a column from a table calculation by "hiding" it? I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are needed. It's like saying, do the calculation including the data in Column A or exclude them. A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to do the same in a table. Thanks Alex |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude a column from a table calculation
Try this, it should leave E column unchanged.
Range("A2:D100, F2:G100").Calculate Be sure you have Calculation in Tools Options set to Manual and the Iteration box unchecked. Regards Robert McCurdy "Metallo" wrote in message ... Hi, Is there a way to exclude a column from a table calculation by "hiding" it? I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are needed. It's like saying, do the calculation including the data in Column A or exclude them. A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to do the same in a table. Thanks Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 28/06/2004 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude a column from a table calculation
Robert,
It does not work. I went to tools, options, set calculation to manual and iteration was already unchecked. Then I highlighted the Columns I want in the calculation, press F9 but nothing happens. Also, I'd like the column which I want to exclude to be hidden, but maybe I can do this after your formula will work?? thanks Alex "Robert McCurdy" wrote: Try this, it should leave E column unchanged. Range("A2:D100, F2:G100").Calculate Be sure you have Calculation in Tools Options set to Manual and the Iteration box unchecked. Regards Robert McCurdy "Metallo" wrote in message ... Hi, Is there a way to exclude a column from a table calculation by "hiding" it? I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are needed. It's like saying, do the calculation including the data in Column A or exclude them. A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to do the same in a table. Thanks Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 28/06/2004 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude a column from a table calculation
Can anybody reply, please?
Alex "Metallo" wrote: Robert, It does not work. I went to tools, options, set calculation to manual and iteration was already unchecked. Then I highlighted the Columns I want in the calculation, press F9 but nothing happens. Also, I'd like the column which I want to exclude to be hidden, but maybe I can do this after your formula will work?? thanks Alex "Robert McCurdy" wrote: Try this, it should leave E column unchanged. Range("A2:D100, F2:G100").Calculate Be sure you have Calculation in Tools Options set to Manual and the Iteration box unchecked. Regards Robert McCurdy "Metallo" wrote in message ... Hi, Is there a way to exclude a column from a table calculation by "hiding" it? I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are needed. It's like saying, do the calculation including the data in Column A or exclude them. A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to do the same in a table. Thanks Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 28/06/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude Cell from Calculation | Excel Discussion (Misc queries) | |||
How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
Exclude non-numeric data from calculation | Excel Worksheet Functions | |||
calculation to exclude weekends | Excel Worksheet Functions | |||
Exclude cells from calculation? | Excel Programming |