multiple coloumn check Edit ***

pantsmonkey

Board Regular
Joined
Jul 2, 2002
Messages
109
Ignore everything after the stars unless further infor is required this is difficult to explain.

How do i sort something like

If a1 and a2 are the same and b1 and b2 are the same then put nothing in c1 and c2.

But

If a1 and a2 are different and b1 and b2 are the same place "1" in c1 and c2.

Coloumn A and B contain spaces so it needs to check each cell exactly.

Thanks hope that makes more sense

*************************************





Hello you wonderful Lads Im almost finished this evil task but have found i dislike the manual way, Theres 1200 + records and theres a quicker way that i dont know about yet.

Some Data

ORIGINAL SHEET Col A | SITE NAME Col B | Dupe Key Col C

Qsum Required Details BORROLOOLA EXCHANGE 1
Qsum Required Details BORROLOOLA EXCHANGE 1
Full Report BORROLOOLA RT RBS-TC 1
Full Report BORROLOOLA RT RBS-TC 1
Qsum Required Details BOURKE EXCHANGE 1 Qsum Required Details BOURKE EXCHANGE 1
Qsum Required Details BOURKE EXCHANGE 1
Qsum Required Details BRANSBY R/T 1
Qsum Required Details BRANSBY R/T 1
Full Report BRIABA R/T 1
Qsum Required Details BRIABA R/T 1
Qsum Required Details BRIABA R/T 1
Qsum Required Details BRIARIE R/T 1
Qsum Required Details BRIARIE R/T 1


My problem is that if the data in coloumn B is repeated ie

Qsum Required Details BORROLOOLA EXCHANGE 1
Qsum Required Details BORROLOOLA EXCHANGE 1

I dont need to touch it But if the Site Name is repeated and the original sheet is different i would like it to show as put a 1 in coloumn C if i can find the multiples from different sheets whilst keeping multiples from the same sheet i will be saved. IE

Full Report BRIABA R/T 1
Qsum Required Details BRIABA R/T 1

In the above the source data (coloumn a) is different but coloumn B is the same thes are the records im looking for

I think basically some kind of

if(a1=a2,1,0) and a if(b1=b2,1,0) may work but i cannot get it sorted.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

pantsmonkey

Board Regular
Joined
Jul 2, 2002
Messages
109
No its more like

If a1(Does not =)a2, b1=b2 then c1andc2 = 1 else paste blank.
 

DRJ

MrExcel MVP
Joined
Feb 17, 2002
Messages
3,853
=If(And(A1=A2,B1=B2),"",If(And(A1<>A2,B1=B2),"",FALSE))

I put false at the end because I don't know what you want if both your criteria is false.

Or do you want to do this with VBA?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,733
Members
414,170
Latest member
Mdm

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