Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
If it is not the right place for my question, please point me to the correct newsgroup. I have a perplexing problem building a macro in excel that I hope someone can help me solve as follows; I have a stream of data values in column AB2:AB14516. And what I would like to do, is to find lowest value in the last highest group of 13 consecutive values, rather than the first group using Excel VBA. Then put that value into cell W3 and the address of that group's range into cell W4. In addition, Identify the address of the five cells ahead of that group that was found and put that address into cell W2. And finally, identify the address of the 22 cells after the group of 13 consecutive high values and put its address into cell W5. Any help at this point would be greatly appreciated! Thanks in advance, CTown |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is Multi-Sequence Search Selection Macro Possible? | Excel Programming | |||
Search in multi dimensional array - URGENT help | Excel Programming | |||
How can I use a VLOOKUP function to search a multi-page workbook? | Excel Worksheet Functions | |||
How can I use a VLOOKUP function to search a multi-page workbook? | Excel Worksheet Functions | |||
multi text search question | Excel Programming |