| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
two dimensional arrays
Is there an Excel function that can point at a two-dimensional array and
return the location of a targeted text string? For example, if there is a 4X4 grid of cells which have text in them, I'd want the formula to return the column and row number within the grid where it finds the word "five." Any ideas? I'd rather not use VBA, but I'll listen to anything. tia, Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2-dimensional lookup | Excel Discussion (Misc queries) | |||
| How to do a 2-dimensional lookup? | Excel Discussion (Misc queries) | |||
| How to: 3 dimensional graph | Excel Discussion (Misc queries) | |||
| Two dimensional sum by week | Excel Worksheet Functions | |||
| Two dimensional sum by week | Excel Worksheet Functions | |||
Threaded Mode
