Excel: Compare four sets of Columns

If there is a formula or a macro for this, that would be great. Using Excel 2010. What I am trying to do here is, I am trying to match all the "Key" columns across all 4 weeks and see if they have the IP column blank. If the IP column is blank across all 4 weeks, I just need to indicate it lets say in column I with "No Activity". There are about 5000 rows and the numbers in column "Key" are always out of order and some Key are added in week 2 and were not there in week 1 so I cant just sort them and compare rows. Here is an example of the data: In this case, the row with Key = 3574 would be the one where I would indicate it with "No Activity" in column I. Thanks in advance!

Week 1 Week 1 Week 2 Week 2 Week 3 Week 3 Week 4 Week 4
Key IP Key IP Key IP Key IP
1234 545 1234 545 1234 545 1234 545
3574 3574 3574 3574

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of February 24, 2017.

For more resources for Microsoft Excel