Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Excel Formulas - Comparing Columns

  • Please log in to reply




  • Member
  • PipPip
  • 44 posts

Not sure if this is the right place to post this question but here goes.

How in Excel can I compare columns on a worksheet with columns on another worksheet and display a result.

Basically I have a list of values on worksheet 1 (master) that have either expired (Have an expiry date usually in the past) or are still live (have no expiry date) and I want to compare a separate list of values on a separate worksheet (slave) to identify what updates need to be applied to the slave to bring it up to date with the master.

I need to know whether there are new entries on the master that are not on the slave and need to identify any entries that are on both that on the master have now expired and also identify whether I have any entries on the slave that do not appear on the master i.e. they now need to be removed from the slave.

The purpose being to be able to identify what changes need to be made to the slave to bring it back in line with the master.

Hope the above makes sense.

  • 0





  • Member
  • PipPipPip
  • 272 posts
Hello JohnnyAlpha,

Perhaps an IF statement and maybe a VLookup would serve your needs. However, could you post a sample of your data lay out and exactly what values need to be compared?


  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP