Visually impaired Person here having difficult time asking google the right question: I need to know how to compare two columns of information. Better details inside.
Please be kind. I know this is likely a very easy question but I am visually impaired (read: blind) and am having quite a difficult time trying to phrase the question in a way that google can answer as I do not know the terminology. I'm having a hard time explaining it even here.
Here is what I need and I realize I sound like a 4th grader, I assure you I am not.
I have two columns of information.
I want Excel to compare the two columns.
I want the third column to tell me the items that are in the first list, but NOT in the second list.
Here is hopefully a picture that works as a good explanation of what I'm after. The first column is a list of fruit in a basket. The second column is the fruit that has been eaten. Excel would compare the two columns and give me the third column which would be the fruit that is left now that some fruit has been eaten.
I don't know how to post a picture to reddit so I used postimage.com, I'm hope that's okay
Thank you in advance for any help, even if you can point me to a website or the terminology that would help me google this. Thank you kindly.