| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula ABSOLUTE with INDIRECT - Is Fill Down Possible?
Hi All,
I have a 5 Column by many Rows Table that has "Sorting" applied to it, the five individual cells that comprise one Row must stay together when sorted; I use the Formula below to absolute the relevant cells in each Row. However, I change the absoluted Row Numbers ("1:1") and ("2:2") individually on each Row. Is it possible to ABSOLUTE the Rows and Fill Down in this Formula? =TEXT(ROW(INDIRECT("1:1")),"00 ")&TEXT(ROW(INDIRECT("2:2"))," 00") Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200511/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill red cells included in formula - ajit | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Formula Fill properties | Excel Worksheet Functions | |||
Threaded Mode
