Start Free Trial

Member_2_7964762

asked on

help with Libre Office Calc

Im using LibreOffice Calc.

I have two separate column of number sets. I want to compare the two and come up with a 3rd column set of numbers from column A that don't have any of the sets of numbers in column B.

This is the answer i rec'd from one member of Experts Exchange.

In C1 type in formula: =IF(ISERROR(MATCH(A1;$B$1:$B$1000000;0))=1;A1;"") and copy formula down from C1 to wherever the last entry is in the B column so (C1-C31 for example).

The formula displays in column C the values that are in the list A and do not exists in list B.

But I cant seem to make it work. Is it possible for you you to show me via a video tutorial or walk me through it so i know what i am doing?

Thanks,
Casey

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Member_2_7964762

ASKER

I need more detailed help.

Does the spreadsheet I attached work with your version of Calc?
I am trying to get an understanding of where the problem is.

Member_2_7964762

ASKER

yours is read only so i cant work with it

Member_2_7964762

ASKER

can we go live and you show me

did you try the steps I have shown above?

Member_2_7964762

ASKER

yes but being a beginner i just am not getting it... i really need someone to create this for me or show me

Thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial