This ones tricky

Hi all,

Sorry about this.

I want a piece of code to set up an alarm to tell me when there is a differentiation in some of the codes.

So i want it to look down column A which will look at the code and see if there is any other cells with this same code in column A. If there is i then want it to check the cell next to it in column B and see if there is a differentiation witht the prices. So if cell A56 has a code of 566.876 in column A and so does cell A108, but they both have different prices in column B then i want an alarm to pop up and let me know or highlight the cells.

Hope this makes sense. Please let me know if it doesnt.

Cheers

Hi,

With an array formula (Control Shift Enter ) in cell D1 :

Please Login or Register  to view this content.

and copy down ...

HTH
Carim

Carim,

I apreciate the help but im not sure it does what i want it to. I want the macro to show me an Alarm if there is any row with the same number in column A but a different on in B.

Is there a way to do this.

Sorry ... read too quickly ...

Please Login or Register  to view this content.

HTH
Carim

Yup, Thats the kind of thing i need, Thanks Carim, youve been a real help.

You are welcome ...

Thanks for the feedback

Carim