ComparingColumns

  • Thread starter Thread starter gh
  • Start date Start date
G

gh

I have 2 spreadsheets, with an id column that is assigned to a person,
in each one. One spreadsheet shows the people who pre-registered for an
event and the other spreadsheet shows the id of the people who attended.
I need to compare those who were registered against those who
attended, to show who was registered that did not show and those who
showed up without pre-registering. Can this be done in Excel?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Unmatched Records 2
Combine two spreadsheets into one 3
Removing Duplicates 5
Excel module: Mark records if it contains names out of another list 4
OpenOffice macros 1
Count Students Who Attended Class? 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Check if the value of one cell can be found in a number of other c 2

Back
Top