I just typed "excel wankers" into my work computer thanks to you lot.

Is there a way for me to compare two identically formatted spreadsheets/worksheets and generate a third worksheet that contains only the rows that aren't in both?

It'll have to be with excel and my (your) wits only, I can't use any external scripting or anything.

Much obliged.