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?
| +178 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 31 | 6h |
| +165 | Leaked Interview Questions to Recruiting Services | 62 | 2h |
| +164 | UBS Tech layoff | 52 | 3d |
| +149 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 2d |
| +65 | How do YOU manage networking requests? | 20 | 21h |
| +61 | Are target prospects getting dumber? | 27 | 2d |
| +34 | MBB Pay Raises | 26 | 3d |
| +27 | Career Crossroads | 5 | 2h |
| +22 | US 2027 SA IB worried about background check | 8 | 7h |
| +22 | Investment Banking is Divine | 5 | 4h |
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
Suscipit aut hic illo nihil amet odio iste. Dolorem eum voluptas nisi voluptatem officia.
Eveniet omnis dolorum et quasi modi ex. Dolorem et et quidem minus et cumque. Sint a sed necessitatibus ea architecto. Necessitatibus non esse id reprehenderit eius nostrum. Impedit quam eligendi maxime.
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...