| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Name Define
Why does this work for a Name definition of a range?
=Sheet1!$A$3:INDEX(DataforCharts!$A:$A,MATCH(9.999 99E+307,DataforCharts!$A:$A)) It works but I can't figure out why. The INDEX returns the value of the last cell with data in it, however if I just replace all of that with the value it does not work anymore. For example this does NOT work. =Sheet1!$A$3:40857 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insertnamedefine | Excel Discussion (Misc queries) | |||
| InsertNameDefine | Excel Worksheet Functions | |||
| Insert / Name / Define | Excel Discussion (Misc queries) | |||
| Insert-Name-Define limit ? | Excel Discussion (Misc queries) | |||
| Insert menu...Define | Excel Worksheet Functions | |||
Threaded Mode
