| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sequential match
Thought I could handle this but it's kicking me good.
If "ALL" of the last 4 entries in colA are in sequential order (ascending or descending) AND are "ALL" either <=, or, = A1, then display B1 in A12 otherwise nothing. A B 70 325 33 4 501 88 76 78 100 130 325 <<<A12 Results Thank you now, and into the future Luke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Criteria & Return Sequential Count | Excel Worksheet Functions | |||
| sequential numbers | Excel Worksheet Functions | |||
| sequential numbers | Excel Discussion (Misc queries) | |||
| Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
| Sequential names on Sequential pages | Excel Worksheet Functions | |||
Threaded Mode
