| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XIRR with non contigous cells
Tomek,
try to use an extra sheet. In there use =Sheet1!A1 and copy for three rows and two columns. Immediately down use =Sheet1!A100 and repeat. Then use your XIRR(). Back in Sheet1 use ='Helper Sheet'!cell number with XIRR(). Change the names of the sheets as necessary, enclosing sheet name in single quotes if it contains space. HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
