Comparig Rows with particular value

Closed
Rakesh Sharma - Nov 18, 2010 at 10:46 PM
 rakesh sharma - Nov 19, 2010 at 04:07 AM
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.

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
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
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.
0
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
0
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".
0