Hi Bob,
Thanks but that is not what I'm looking for. I want to line up 2012 with 2011 and group them all by account number. Please refer to the file below to illustrate what I am trying to do. I tried using a vlookup in which excel takes the first 2012 account number, looks it up in the 2011...
Hi Everyone,
I just came across Chandoo and joined today. My name is Mike. This is a great forum and very helpful. I'm looking for a quick-fix to this data. It is 2011 and 2012 expense data with account numbers. Some account numbers occur only in 2012, some only in 2011, and some accounts have...