| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find string/date in array to get value of nearby cell
I have an array that contains all sorts of text in column A.
I would like to know how I can search for certain date (example "6-Aug") and then get the value of the cell that is 5 rows below that date? The date is a web query where the only pattern I can find is the data I need for each date is 5 rows below the corresponding date. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula to find date | Excel Worksheet Functions | |||
| Excel keeps changing my formulas to include nearby cells. | Charts and Charting in Excel | |||
| Find & Replace String Array - More Than 255 Characters? | Excel Programming | |||
| Compare String in Cell to an Array | Excel Programming | |||
| macro to find date in the string | Excel Programming | |||
Threaded Mode
