Aligning duplicates on the same rows in Excel


Cool Excel Things You Can Do

Aligning duplicates on the same rows in Excel.

One of the projects I’ve worked on involved thousands of agreement numbers. Each agreement was assigned a status depending on what stage it’s in. I needed to find a way to track agreements that had a status change based on comparing previous and current day feeds. This wouldn’t be such a big deal if we’re dealing with a small number of agreements. However, since I was dealing with close to 4,000 agreements, I needed to find a better and faster way to do it.

This was my solution:

=IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(C:C,MATCH(A1,C:C,0)))

This formula completely automated the task of comparing thousands of agreements. Here is how it works:

Let’s say you have two columns in Excel like the one below. Column 1 and column 2 have some identical values, but they are not aligned on the same rows. Here is what you need to do to…

View original post 185 more words