help with Libre Office Calc

Member_2_7964762
Member_2_7964762 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Have a look at the attached spreadsheet. Your formula seems to work.
sample.ods
once you paste the formula into the first row press enter

select that cell and click CTRL-C to copy the formula

now select all the cells below that one

click on CTRL-V to paste the formula into the other cells

That's all!

Author

Commented:
I need more detailed help.
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

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

Author

Commented:
yours is read only so i cant work with it

Author

Commented:
can we go live and you show me
did you try the steps I have shown above?

Author

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

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial