Related:
- Comparig Rows with particular value
- Repeat rows in excel - Guide
- How to delete rows in word - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- How to insert multiple rows in microsoft excel - Guide
- Saint rows 2 cheats - Guide
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
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
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.
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.
Nov 19, 2010 at 04:07 AM
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