paroxsitic
New Member
- Joined
- Jan 19, 2005
- Messages
- 22
This is quite difficult to explain so I have attached an excel file here: http://minus.com/mQF3Qrsoh
If you look at the excel file column F is what I have currently, column G is what I want.
Basically, the formula will look in the past 5 values for a value of "x" if it finds it, then the next 5 rows are *
I accomplish this by the formula: =IF(ISNA(VLOOKUP("x",E11:E15, 1, FALSE)), "", "*")
However, if there is a second x within 5 cells of another x, then the second x should be ignored completely.
That's the part I don't know what to do.
See this screenshot as well, if you dont want to download excel file:
http://i.stack.imgur.com/LRRLF.png
If you look at the excel file column F is what I have currently, column G is what I want.
Basically, the formula will look in the past 5 values for a value of "x" if it finds it, then the next 5 rows are *
I accomplish this by the formula: =IF(ISNA(VLOOKUP("x",E11:E15, 1, FALSE)), "", "*")
However, if there is a second x within 5 cells of another x, then the second x should be ignored completely.
That's the part I don't know what to do.
See this screenshot as well, if you dont want to download excel file:
http://i.stack.imgur.com/LRRLF.png
