Posted to microsoft.public.excel.worksheet.functions

dan

external usenet poster

Posts: 866

How do I increment the row and column of a cell in a formula?

I would like to drag a formula down a column, where the cell referred to is
one column right and one row down from the previous cell;

=A1
=B2
=C3
....

Thanks,
Dan

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to Increment a number upon a match in an adjacent cell	Nolene	Excel Worksheet Functions	9	October 2nd 09 10:04 PM
Formula to increment sequence only if text in a particular cell	Mills	New Users to Excel	6	July 9th 09 01:58 AM
increment cell reference in a formula	MarkW1307	Excel Worksheet Functions	3	January 9th 09 11:31 AM
Need formula to increment cell reference every 8th row	Sandy Crowley	Excel Discussion (Misc queries)	11	November 7th 08 02:33 PM
how to auto increment cell location within formula	Bill	Excel Worksheet Functions	3	February 16th 06 02:23 PM

All times are GMT +1. The time now is 12:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us