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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
=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?
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

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