I need to learn how to compare two spreadsheets in Excel to identify
differences between the two. For example, if I have one spreadsheet with a
list of staff and staff numbers, and a different spreadsheet listing staff
and staff numbers, I need to be able to compare the two to identify any
employees whose staff number differs between the two. I am a new user so I
do not know which function to try - someone said match???

Many thanks


--
Kind regards

Ann Shaw