| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
#REF! errors due to number of rows
When you import the data, do you copy it over what might be there
already? It might be better to clear all the data first and then import - your formula for Extension can then be copied down for as many rows as you have in this latest import without giving rise to the #REF error. Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
| Counting the number of rows | Excel Worksheet Functions | |||
| Number columns and rows in Excel, Example: C027R36 | Setting up and Configuration of Excel | |||
| Dynamic number of ROWS | Excel Worksheet Functions | |||
Threaded Mode
