| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching for Data Values in a Column - Formula Only
All,
Column A will contain a variable number of rows that contain values from 1 to 4. I'd like to create a formula in cell B1 that searches column A from top to bottom for the first occurrence of 3, then searches backwards (towards row #1) for the first prior instance of 1, then writes out the number of columns between the two cells. I got as far as finding the first occurrence of 3 using this formula "=MATCH(3,A1:A100,0)", but that's as far as I got. Any help will be greatly appreciated. Mark D'Agosta |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula: values in one column based on corresponding data | New Users to Excel | |||
| Formula searching data that dose not equal two criteria | Excel Discussion (Misc queries) | |||
| Searching data in a column via Input Box | New Users to Excel | |||
| Searching for partial data in a column | Excel Discussion (Misc queries) | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
