I have two documents in excel--they're about 260 rows and 12 columns each, and I want quickly identify the differences between them. Is there a way for excel to automatically highlight all the differences for me?
| +166 | Return Rates For Interns Are Falling? | 51 | 1h |
| +129 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 14h |
| +96 | I am a drunk MD AMA | 36 | 10h |
| +74 | London IB BB is a challenge | 41 | 10h |
| +62 | VP Lifestyle at Top BB Coverage Groups | 39 | 20h |
| +56 | An Outsider’s View of RX Banking Out of College | 7 | 3m |
| +48 | SharePoint makes IB hours HELL | 15 | 2d |
| +46 | KISSED MY VP… HELP!!! | 11 | 3m |
| +42 | momentum of Rx groups | 16 | 4h |
| +39 | Fired during interview | 8 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
There is probably an easier way, but you can easy put in if statements to compare the content on a 3rd worksheet, and have it return 1 or 0, so something like =if(sheet1 A1 = sheet2 A1, 0,1), then have a sum function for all of the columns and rows. If you want to really separate it to find differences then have it at the end of each row or column a sum function to find the specific location. at the bottom of each column so you can see if th
Nulla nihil et nam ullam corrupti. Tenetur ut a molestiae nisi ut fuga. Laudantium alias rerum numquam animi. Aperiam architecto accusamus vel illo debitis. Quisquam laboriosam fugit officiis non nisi amet labore. Modi soluta qui eveniet fugiat aut non excepturi omnis.
Nihil odit et recusandae maiores dolore dicta doloremque voluptatibus. Alias aut est quaerat et ducimus. Sunt nostrum voluptatibus aut ut officiis voluptatem. Quia maxime vel hic vitae tenetur ex.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...