Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

I need to See which numbers are missing from two lists in excel

I have a master list of numbers. then i have a list of numbers from barb and from cathy. How can i figure out which numbers are in Barb's list but not Cathy's and which are in Cathy's but not Barbs

I have attached a sample here. I think you would use vlookup?

  • 2
1 Solution
the following formula works for:
column D
column E
column F
but i see that you have some values stored as text and some as numbers and this might not work, also not all the values are the same length correct?
if all Cathy's are text then this will work:
Column D
Column E
Column F

if not make sure that all three columns are text or all theree are numbers

see this link
jtovar3Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now