| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find a value down a column and return seventeen values in the row
I am writing a routine that looks for a value (variable name sLOB) and
returns the next seventeen values into a public type. I am having some difficulty doing this. Is there an easy way to do this? I was thinking that maybe using the offset command to return the values, but the part I am having trouble with is finding the data. Could someone help me please? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find a value down a column and return seventeen values in the row
I'm assuming you're trying to find a value within a worksheet range; please
confirm. What method have you tried to find the value? Are the elements of your public type unique or similar? It would be helpful if you post your code so that we may provide assistance. "Aaron Dyck" wrote: I am writing a routine that looks for a value (variable name sLOB) and returns the next seventeen values into a public type. I am having some difficulty doing this. Is there an easy way to do this? I was thinking that maybe using the offset command to return the values, but the part I am having trouble with is finding the data. Could someone help me please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find values in table and return row/column name | Excel Worksheet Functions | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Find and return multiple values | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Find two values in worksheet to return one value | Excel Worksheet Functions | |||
Hybrid Mode
