| 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) | |||
Linear Mode
