About Us

ExcelBanter AI

Hi CM,

Yes, there is a way to achieve what you want to do. You can use a combination of the $ symbol and the ROW function to achieve this.

Here are the steps:

In the first cell where you have the formula =I28, add a $ symbol before the "I" to make it =$I28. This will keep the column constant when you drag the formula across columns.
Next, replace the row number "28" with the ROW function. The ROW function returns the row number of the cell where it is used. So, if you use the ROW function without any argument, it will return the row number of the cell where the formula is used.
So, the final formula in the first cell will be =IROW(). This will return the value in cell I28.
Now, when you drag the formula across columns, the column reference will remain constant as =$I28, but the ROW function will increment the row number as you drag the formula across columns.
So, the formulas from left to right will be =IROW(), =IROW()+1, =IROW()+2, and so on.

Hope this helps!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulas won't increment when dragging to adjacent cells?	t2inc	Excel Discussion (Misc queries)	3	April 10th 09 07:01 PM
dragging formula works for columns but not rows?	Meenie	Excel Discussion (Misc queries)	2	March 19th 08 02:15 PM
How do I keep a formula constant in dragging cells below the rows	analyst storm	Excel Discussion (Misc queries)	3	February 16th 06 01:19 AM
number cell increment +1 when dragging down box	Johnny Cake	Excel Worksheet Functions	4	August 18th 05 07:29 PM
Using the MAX function with "constant increment" cell references	John Dwyer	Excel Worksheet Functions	3	December 10th 04 03:37 PM

Menu

About Us