U
U
unlik2015-10-23 19:17:53
excel
unlik, 2015-10-23 19:17:53

Remove base 1 from base 2?

There are 2 bases consisting of numeric strings.
We need to remove rows from base 2 that match base 1.
How can I do it?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
T
Taxist410, 2015-10-23
@Taksist410

1. add a new column to base 1 and fill it with number 1
2. add a new column to base 2 and fill it with number 2
3. Copy base 2 down under base 1 in excel so that the columns match
4. Sort the total base alphabetically.
5. add a third column and write an expression there so that it equals 1 if adjacent rows from different bases are equal to
6 sort by the third column and delete everything where 1
7. Sort by the second column and delete the remnants of base 1.

P
Puma Thailand, 2015-10-23
@opium

Select with join by mismatch should help

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question