| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a result in an array in the same row as a minimum
In B1 you have the text $A$2000
In C1 enter =INDIRECT(B1) Gord Dibben MS Excel MVP On Wed, 5 May 2010 13:46:02 -0700, dbasmb wrote: Max: Yeah!! That's the ticket!!! Thanks for your help. Is there any easier way to answer the last part of my question?? Given an address in text, such as '$A$2000', how do I use that to get the contents of $A$2000?? Thanks again, Doug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I set a minimum(or default) value a a result from formula | Excel Discussion (Misc queries) | |||
| Minimum array formula. | Excel Worksheet Functions | |||
| Array Formula Minimum Excluding Text | Excel Discussion (Misc queries) | |||
| How do I set a minimum result value in an Excel formula? IE 100 | Excel Worksheet Functions | |||
| Finding minimum value across selected rows of an array | Excel Worksheet Functions | |||
Threaded Mode
