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.
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.