Quote:
Originally Posted by Mischa_N
Thanks, highly appreciated, it is driving me up the wall ;-)
|
Try this in column B:
=AND(INDEX(A:A,ROW())=INDEX(A:A,ROW()-1),INDEX(B:B,ROW())=INDEX(B:B,ROW()-1))
I wish I could say I solved the problem for you, but alas I sought help elsewhere and got the answer far quicker than I'd have worked it out.
It's not what you know, it's who you know that knows far more than you know! ;)