Related:
- Comparig Rows with particular value
- How to delete rows in word - Guide
- Repeat rows in excel - 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
- Vba insert multiple rows - Guide
- Excel duplicate rows delete - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
18 Nov 2010 à 23:37
18 Nov 2010 à 23:37
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.
19 Nov 2010 à 04:07
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