First time here? Check out the FAQ!

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.

2 | No.2 Revision |

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.

3 | No.3 Revision |

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.

4 | No.4 Revision |

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.

5 | No.5 Revision |

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

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.

6 | No.6 Revision |

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

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.

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.