auto fills

**raymonddic** · 06-07-2007, 03:34 AM

Dear all,

I am having a problem with this excel formulation. Hope someone can help me.

-------------column 1-----------------column 2------------------column 3
row 1____'sheet1'A3-'sheet1'A2___'sheet1'A4-'sheet1'A3___'sheet1'A5-'sheet1'A4
row 2____'sheet1'B3-'sheet1'B2___'sheet1'B4-'sheet1'B3___'sheet1'B5-'sheet1'B4
row 3____'sheet1'C3-'sheet1'C2___'sheet1'C4-'sheet1'C3___'sheet1'C5-'sheet1'C4

What i want is if i drag the cell from left to right, eg. row 3, it change from C5 to C6 and so on until C100.
When i drag the cell down, it will change from C3 to D3, and so on until Z3.

Currently if i drag it down, instead of changing from A3 to B3, it change from A3 to A4. I don't want this, i want A3 to B3.

Please help. Thanks a lot.

**sweep** · 06-07-2007, 03:55 AM

You can do this by creating a new list of numbers from 65 to 91, and using the CHAR() function to introduce the letter into a concatenated formula.

That probably sounds like complete tosh - please see attachment

**raymonddic** · 06-07-2007, 04:13 AM

Originally Posted by sweep

You can do this by creating a new list of numbers from 65 to 91, and using the CHAR() function to introduce the letter into a concatenated formula.

That probably sounds like complete tosh - please see attachment

Thanks but it doesnt work this way. Maybe you can show me a formula to concatenate. Thanks.

**sweep** · 06-07-2007, 04:48 AM

The sheet I attached doesn't work?

**raymonddic** · 06-07-2007, 05:34 AM

Thanks a lot, the formula is doing what it suppose to do,
="'sheet1'"&CHAR(E3)&"3-'sheet1'"&CHAR(E3)&"2"
and i get 'sheet1'C3-'sheet1'C2 but my problem is i cannot get the value for 'sheet1'C3 and also 'sheet1'C2.... i am very weak in excel and hope you can guide me how to get the value of C3 to minus the value of C2 from sheet 1. Thanks.