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!
<tbody>
</tbody>
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!
A | B | C | D | E | F | G | H |
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 |
<tbody>
</tbody>