ComparingColumns
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 |
ComparingColumns
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx gh wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com