Anyone know how to...

[ratboy]

I need to take one list and then delete the copies of that list from another.

eg. I have the list

xzy.co.uk
ggg.co.uk

I need to delete them from this list:

xzy.co.uk
xxx.co.uk
abc.co.uk
ggg.co.uk

leaving

xxx.co.uk
abc.co.uk

Any ideas how I can do that?

Cheers
johnny

 

[retired_member12]

In Excel:
Lump them all together one per line, place them in a spreadsheet column, data sort them.
In the second column at B2, use the IF logic function, eg:

=IF(A2=A1,1,0)
Fill down the B2 cell equal to the bottom of your first column.

In the third column at C1, use the IF logic function, eg:

=IF(A1=A2,1,0)
Fill down the C1 cell equal to the bottom of your first column.

Select the entire of columns B & C, copy and 'paste special' as 'values'. You'll be left with B1 & C(??bottom cell) empty, simply enter 0 or 1 in them both to match the result of the rule you applied in the other cells.

Finally, select the whole worksheet, data sort (decending) the B column, delete all the rows where a B cell contains a 1. Select the whole worksheet again, data sort the C column, delete all the rows where a C cell contains a 1.
Tidy up by data sorting (accending) the A column, and you have your list.

I'm sure there is an easier way, but it'll at least do the job for you for now.

 

[ratboy]

Nice! I'll give that a shot and see how I get on :lol:

 

[zee]

question

intel. questions and very helpful answers....make casual chat enjoyable...zee

 

[ratboy]

Everyday is a school day Zee!!

 

[zee]

questions

too right,older than you , the more I learn, the more I find out I have to learn....zee

 

[julian]

questions are a burden to others, answers are a prison for one's self.