Thursday, 1 September 2016

How To Do : Microsoft Office Excel - Compare 2 Sets of Data

A bit different thing today, a simple task but greatly helps me in getting my jobs done fast. I am in the middle of housekeeping our Citrix licenses as it needs to be renewed. Due to the fact that we are using User/Device model, some users who are already left the Company might have their ID still utilizing the licenses. By freeing up the licenses, it will help the Company to reduce Operational costs and assign the licenses to the other users. Well, it is almost year end, and everybody is coming up with their plan for performance review, why shouldn't I? ^__^!



Description :
To compare 2 sets of data (Data 01 : all users who are utilizing the licenses, Data 02 : all disabled users id AD). I there are match, it means the users can be removed and the licenses can be released.


How To Do :


  1. Launch MS Excel, put the first group of data in Column A

  2. Put the second group of data in Column C

  3. Put the following formula in Cell B1:
    Syntax :
    =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)

  4. Change the formula a bit so data in Column A could be compared against all data in Column B. In my case as I have 10 data, I changed from $C$5 to $C$10.

  5. Next, copy the formula in B1 to B10 (in may case, yours might be more / lesser than that).

  6. End result.

     
Share:

0 comments:

Post a Comment