| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference error in excel
On Oct 29, 5:23 am, JE McGimpsey wrote:
One way: =MIN(INDEX(INDIRECT("'Sheet1'!A:IV"),,COLUMN())) So make In article .com, wrote: Now, I am trying to drag the formula across IV cells using the + icon, so that MIN(INDIRECT("'Sheet1'!A:A")) is for cell A1 and MIN(INDIRECT("'Sheet1'!IV:IV")) is for cell IV1. The series is not getting filled instead the formula is just copied. Anyway to fill the series. Please let me know. Thanks- Hide quoted text - - Show quoted text - Excellent. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - Business Explorer - Missing object or reference error | Excel Discussion (Misc queries) | |||
| "Reference not valid" error when I try to edit the macro in excel | Excel Discussion (Misc queries) | |||
| reference #value error | Excel Worksheet Functions | |||
| removal of circular reference error on excel workbook load | Excel Programming | |||
| VBA Action on excel #Reference! error 4? | Excel Programming | |||
Threaded Mode
