Comparig Rows with particular valueClosed

Question

Hello,

I have a excel file, and in coloumns B if the value is "OK", Than there should not to do any thing other wise whereever there is mismatch in value, than value in Coloumn A should be mentioned in any one cell representing that value in coloumn B is not equal to "OK".

Please help me either by VBA Code or an Excel Formula.

Thanking you,
Regards
Rakesh.

venkat1926 · Answer

I am rephrasing:
if colum b value is :ok" then leave it as it is
if not then copy value in A column to B column 

suppose original data is like this 

hdng 1	hdng 2
a	
s	ok
d	
f	ok
g	


now in C2 copy this formula 

=IF(B2="ok","ok",A2)
copy C2 down

if you want you can now delete column B .  But I suggest you keep it so that you will know what the original data is.

rakesh sharma · Answer

thanks rephrasing for your support but the solution is not like this, I had done this in C Column. Now in C Column if there is other than "OK" than it should prompt that there is error and check respective row where errors occurred or where value is not "OK".

Comparig Rows with particular value

2 replies

Subscribe To Our Newsletter!