This ones tricky

[test1986]

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

[Carim]

Hi,

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

Please Login or Register  to view this content.

and copy down ...

HTH
Carim

[test1986]

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.

[Carim]

Sorry ... read too quickly ...

Please Login or Register  to view this content.

HTH
Carim

[test1986]

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

[Carim]

You are welcome ...

Thanks for the feedback

Carim