Comparig Rows with particular value

Rakesh Sharma - Nov 18, 2010 at 10:46 PM
 rakesh sharma - Nov 19, 2010 at 04:07 AM

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,

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 18, 2010 at 11:37 PM
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
s ok
f ok

now in C2 copy this formula


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
Nov 19, 2010 at 04:07 AM
thanks for your support,

I had already done this, but i required that message should be prompted and it will tell in which row value is not "OK".
rakesh sharma
Nov 19, 2010 at 04:05 AM
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".