Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|