Macro code required

[pavanranjan]

Dear Sir

I need the macro to perform the below steps for checking unique values

Inv No Code Qty per unit
IN2030125 IZ131 20 20
IN2030126 IS256 39 33.69
IN2030127 IS269 58 47.38
IN2030128 IS290 77 61.07
IN2030129 IS299 96 74.76
IN2030130 uq698 115 88.45
IN2030131 dh987 134 102.14
IN2030132 df369 153 115.83



Inv No Code Qty per unit Check
IN2030125 IZ131 20 20 Data is true
IN2030131 dh987 39 33.69 Data is true
IN2030131 dh987 58 36.5 Data is incorrect

 

[onlyadrafter]

Hello,

I think you need to clarify the rules for checking the data, as I get different results than you.

What you need to do, without a macro, is the following.

In a column after the unit column you need to add a cell

=A2&b2&C2&D2 (use the first row of data)

then in the second area of data add a formula

=IF(ISERROR(MATCH(E13,$E$2:$E$9,0)),"Data is incorrect","Data is true")

change cell refs as required

E13 is the combined cell ref for the second area
E2:E9 is the combined cell ref area for the first area.