Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The best way of doing some comparisons on large amount of data would be database, but it is required that you understand database tables, SQLs etc. You probably don't, because if you do, then you would probably not ask this question.

If I understand correctly you have two lists of data. First list (e.g. list A) is in column A and second list (e.g. list B) is in column B. You have some data in list B that does not exists in list A. But as I understand you have no item in list A that does not exists on list B.

Simple sample: A1: AAA A2: BBB A3: CCC B1: BBB B2: DDD B3: CCC B4: AAA

In C1 type in formula: =IF(ISERROR(MATCH(B1;$A$1:$A$1000000;0))=1;B1;"") and copy formula down from C1 to C4. The formula displays in column C the values that are in the list B and do not exists in list A.

Hope this helps. If not please describe your problem in more detail.

The best way of doing some comparisons on large amount of data would be database, but it is required that you understand database tables, SQLs etc. You probably don't, because if you do, then you would probably not ask this question.

If I understand correctly you have two lists of data. First list (e.g. list A) is in column A and second list (e.g. list B) is in column B. You have some data in list B that does not exists in list A. But as I understand you have no item in list A that does not exists on list B.

Lets try to solve this problem using LibreOffice Calc. Simple sample: A1: AAA A2: BBB A3: CCC B1: BBB B2: DDD B3: CCC B4: AAA

In C1 type in formula: =IF(ISERROR(MATCH(B1;$A$1:$A$1000000;0))=1;B1;"") and copy formula down from C1 to C4. The formula displays in column C the values that are in the list B and do not exists in list A.

Hope this helps. If not please describe your problem in more detail.

The best way of doing some comparisons on large amount of data would be database, but it is required that you understand database tables, SQLs etc. You probably don't, because if you do, then you would probably not ask this question.

If I understand correctly you have two lists of data. First list (e.g. list A) is in column A and second list (e.g. list B) is in column B. You have some data in list B that does not exists in list A. But as I understand you have no item in list A that does not exists on list B.

B.

Lets try to solve this problem using LibreOffice Calc. Simple sample: A1: AAA AAA
A2: BBB BBB
A3: CCC CCC
B1: BBB BBB
B2: DDD DDD
B3: CCC CCC
B4: AAA

In C1 type in formula: =IF(ISERROR(MATCH(B1;$A$1:$A$1000000;0))=1;B1;"") and copy formula down from C1 to C4. C4.
The formula displays in column C the values that are in the list B and do not exists in list A.

Hope this helps. If not please describe your problem in more detail.

The best way of doing some comparisons on large amount of data would be database, but it is required that you understand database tables, SQLs etc. You probably don't, because if you do, then you would probably not ask this question.

If I understand correctly you have two lists of data. First list (e.g. list A) is in column A and second list (e.g. list B) is in column B. You have some data in list B that does not exists in list A. But as I understand you have no item in list A that does not exists on list B.

Lets try to solve this problem using LibreOffice Calc.
Simple sample: sample:
A1: AAA
A2: BBB
A3: CCC
B1: BBB
B2: DDD
B3: CCC
B4: AAA

In C1 type in formula: =IF(ISERROR(MATCH(B1;$A$1:$A$1000000;0))=1;B1;"") and copy formula down from C1 to C4.
The formula displays in column C the values that are in the list B and do not exists in list A.

Hope this helps. If not please describe your problem in more detail.

The best way of doing some comparisons on large amount of data would be database, but it is required that you understand database tables, SQLs etc. You probably don't, because if you do, then you would probably not ask this question.

If I understand correctly you have two lists of data. First list (e.g. list A) is in column A and second list (e.g. list B) is in column B. You have some data in list B that does not exists in list A. But as I understand you have no item in list A that does not exists on list B.

Lets try to solve this problem using LibreOffice Calc.
If I understand correctly you have two lists of data. First list (e.g. list A) is in column A and second list (e.g. list B) is in column B. You have some data in list B that does not exists in list A. But as I understand you have no item in list A that does not exists on list B.

Simple sample:
A1: AAA
A2: BBB
A3: CCC
B1: BBB
B2: DDD
B3: CCC
B4: AAA

In C1 type in formula: =IF(ISERROR(MATCH(B1;$A$1:$A$1000000;0))=1;B1;"") and copy formula down from C1 to C4.
The formula displays in column C the values that are in the list B and do not exists in list A.

Hope this helps. If not please describe your problem in more detail.

The best way of doing some comparisons on large amount of data would be database, but it is required that you understand database tables, SQLs etc. You probably don't, because if you do, then you would probably not ask this question.

Lets try to solve this problem using LibreOffice Calc. If I understand correctly you have two lists of data. First list (e.g. list A) is in column A and second list (e.g. list B) is in column B. You have some data in list B that does not exists in list A. But as I understand you have no item in list A that does not exists on list B. B. You would like to know which data from list B do not exists on list A. Is it?

Simple sample:
A1: AAA
A2: BBB
A3: CCC
B1: BBB
B2: DDD
B3: CCC
B4: AAA

In C1 type in formula: =IF(ISERROR(MATCH(B1;$A$1:$A$1000000;0))=1;B1;"") and copy formula down from C1 to C4.
The formula displays in column C the values that are in the list B and do not exists in list A.

Hope this helps. If not please describe your problem in more detail.