Some one help if you knowhow to do this...?

benyam

New Member
Joined
Sep 12, 2002
Messages
4
I am trying to do the following
I have to sets of data in column 1 and 2
if the data are the same i want delete the data in column 2 but if the data dont much then i want keep both.

example

column1=========column2=========I want it as
140s street==== 125s street==keep both as is
hello============hello=========delete data
in column 2

any one know how to this?
This message was edited by benyam on 2002-09-16 10:28
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Use an Advanced AutoFilter with a Criteria (eg., =A2=B2) as shown below. Delete the matching rows (4 and 6 in the example below). See the Excel Help topic for "Examples of advanced filter criteria". Especially, note the paragraph entitled, "Conditions created as the result of a formula".
Book1
ABCDEFGHIJKL
1Field1Field2
2ApplesBananasFALSE
3BananasGrapes
4GrapesGrapes
5OrangesApples
6ApplesApples
7BananasOranges
8GrapesBananas
9
Sheet1
 

sen_edp

Well-known Member
Joined
Mar 13, 2002
Messages
555
hello
here is an example using the exact function
(case sensitive)
Book1
ABCD
1COL-ACOL-BCHECK
2oneone 
3oneone 
4oneone 
5oneone 
6oneone 
7oneone 
8onetwotwo
9oneone 
10oneone 
11oneone 
12oneone 
13oneone 
14oneone 
15onetwotwo
16oneone 
17oneone 
18oneone 
19onetwotwo
20oneone 
21oneone 
22oneone 
Sheet1


you can copy the range c2:c22 to b2:b22
using paste special, values.

hth
 

Watch MrExcel Video

Forum statistics

Threads
1,122,519
Messages
5,596,635
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top