Thanks Bob, that is very close to what I'm after, but one strange thin
though. The code seems to ignore the first if statement to some degree


In some places it starts exactly where it should, but in others i
starts displaying the result in cells that have a lesser value tha
[D$1] = [$B3] And [D$1] <= [$C3]


There are some cases where D1 is less than B3 but the code start
anyway.

But the transition to the next value from AK to AL is working well.

Thanks

--
Message posted from http://www.ExcelForum.com