Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel why cant A(row()) replace A1 or A2 to repet formula dn rows
I want to copy formula down many rows but don't want to have to retype row
numbers at every different row |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel why cant A(row()) replace A1 or A2 to repet formula dn rows
I assume you're wanting to "build" a cell reference that increments as you
copy a formula. Post the formula you want to copy and include a more detailed explanation. -- Biff Microsoft Excel MVP "jimmy" wrote in message ... I want to copy formula down many rows but don't want to have to retype row numbers at every different row |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel why cant A(row()) replace A1 or A2 to repet formula dn rows
=INDIRECT("A" & ROW(A1))
-- Gary''s Student - gsnu200909 "jimmy" wrote: I want to copy formula down many rows but don't want to have to retype row numbers at every different row |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel why cant A(row()) replace A1 or A2 to repet formula dnrows
jimmy wrote:
I want to copy formula down many rows but don't want to have to retype row numbers at every different row this is the easiest way. http://www.ehow.com/how_4734730_form...ning-fast.html gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA | Excel Discussion (Misc queries) | |||
Excel - Find and Replace from rows to separation by commas | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
IF formula in Excel / Replace numbers with 'words' | Excel Discussion (Misc queries) | |||
How do I replace my missing Formula bar in Excel? | Excel Discussion (Misc queries) |