Hey guys,
I suck at Excel, officially.
What I have/need is the following:
Report of PCs laid out as the following:
Column A | Column B | Column C | Column D
Service Tag | Username | Service Tag | Username
The differences between column A, B and C, D is that the results are 3 months apart. So names assigned to service tags have changed etc.
What I need is excel to perform a sort or some kind of comparison between the two service tag columns so they match up and it brings the usernames along next to it, so we can see who is now assigned to that machine, and then the gaps left are where machines were there previously but are no longer in the system.
The number of Service tags now isn't the same as before as machines have been removed from the system etc.
Hopefully that all makes sense!
TIA,
Jake
I suck at Excel, officially.
What I have/need is the following:
Report of PCs laid out as the following:
Column A | Column B | Column C | Column D
Service Tag | Username | Service Tag | Username
The differences between column A, B and C, D is that the results are 3 months apart. So names assigned to service tags have changed etc.
What I need is excel to perform a sort or some kind of comparison between the two service tag columns so they match up and it brings the usernames along next to it, so we can see who is now assigned to that machine, and then the gaps left are where machines were there previously but are no longer in the system.
The number of Service tags now isn't the same as before as machines have been removed from the system etc.
Hopefully that all makes sense!
TIA,
Jake