Quote Originally Posted by Ursul View Post
So I found away around it but it requires an extra formula in col C so have a look at this:

Attachment 271319

That's perfect thank you!

I was having a heap of issues trying to get it to work over two columns and also handle the duplicates. But that extra column makes a huge difference. Thanks again!