| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locate values in range
Not sure if this can be done with cell formulas...
I want to create a function so that given a range that is 20 x 30, it would return the row and column coordinated for each cell containing a particular value (the letter "N"). Any idea if this doable with functions? or would this require VBA? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locate a cell value within a range and return its reference | Excel Discussion (Misc queries) | |||
| Need a formula to locate the blank cells within the range | Excel Discussion (Misc queries) | |||
| locate and SUM values from LOOKUP rows? | Excel Worksheet Functions | |||
| Locate month n year from range of date | New Users to Excel | |||
| How can I locate the second to last value in a range? | Excel Worksheet Functions | |||
Threaded Mode
