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

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

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
Office Version
  1. 365
Platform
  1. Windows
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,095
Messages
5,835,363
Members
430,352
Latest member
xvidzoro

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