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
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,563
Messages
6,114,329
Members
448,564
Latest member
ED38

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
Back
Top