Thread: How do I increment the row and column of a cell in a formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
  
Posts: 866
Default 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 QuoteReply With Quote