| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use FIND to return an array of items
I am using Excel 2003 with Windows XP.
I need to be able to return an array of the cell addresses of all occurrences of a certain value in a sheet, preferably using the FIND command. Anyone have a clue as to how to do this? If so, could you please post an example function or code? Thanks much in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a value in an array and return cell address | Excel Worksheet Functions | |||
| Find Max in array- return corresponding cell | Excel Worksheet Functions | |||
| Array Formula to find Average Return | Excel Discussion (Misc queries) | |||
| Find values in table and return correpsonding data in array | Excel Programming | |||
| VBA Syntax for VLOOKUP to return array of return values | Excel Programming | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
