no doesnt work i know the formula is correct its just that it is putting the

formula in cell M1 rather than the whole of column M

if you want =e1-f1 in col M then do that. If you want e2-f2 then grab the

fill handle in cell m1 and copy down.

--

Don Guillett

SalesAid Software

XXXX@XXXXX.COM

the

all

fill handle in cell m1 and copy down.

--

Don Guillett

SalesAid Software

XXXX@XXXXX.COM

the

all

jeniss

In M1 enter =K1-L1

Move the mouse pointer to the bottom right corner of M1.

You will see a black square lump.

Double-click on that lump to replicate the formula down as far as there is

data in column L.

=K1-L1 will be incremented to =K2-L2 and K3-L3 etc.

Gord Dibben Excel MVP

On Thu, 6 Jan 2005 08:45:04 -0800, "jenniss"

In M1 enter =K1-L1

Move the mouse pointer to the bottom right corner of M1.

You will see a black square lump.

Double-click on that lump to replicate the formula down as far as there is

data in column L.

=K1-L1 will be incremented to =K2-L2 and K3-L3 etc.

Gord Dibben Excel MVP

On Thu, 6 Jan 2005 08:45:04 -0800, "jenniss"

1. My I's are coming up i's. (lower case)

2. Graffiti 2 - Capital k's, t's and i's

3. Fonts not clear, i's and L's are red in color

4. Tabbing from column to column to column in a 5 column document.

5. Putting Column Values into Column Headings

6. the columns, the columns, what what the columns

7. DataGridView - refreshing calculated columns when move from column to column.

8. How to put spacer column between 2 columns in datalist

9. Referencing date column A & time column B to get info from column

10. Add up contents of column, if nothing in that column add up contents of other column

11. if column I is blank, then puts an "a" in column A.

12. Chart with One Column Column and Two Stacked Columns

13. divide column(x) by column(y) to give column(x/y) in excel?

14. Put numbers in column B cells when Value Change in Column A cells

15. Combined columnar chart(3 - 5 columns) and stacked column (1 column, 2 series) as one chart

3 post • Page:**1** of **1**