Skip to main content

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.

     

Comments

Popular posts from this blog

How To Change NetBIOS Name of A Computer

So yes... After 4 months without new contents, so I started with this. It looks easier to do (well, it is), but before you do that, you may want to read this  to understand the difference between hostname and netBIOS, then starts to explore on when to use them, their limitations etc etc. I won't discuss here (or maybe not today). So let's back to the topic.   Description : Changing NetBIOS Name of A Computer. ComputerName : NetBIOS : How To Do :  Go to Start > Run , and type REGEDIT  Browse to Computer > HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > ComputerName > ComputerName At the right side, double click at ComputerName string, and put correct Value data . Press OK .  Then you will get this Reboot your computer / VM. Once it is up, double check your netBIOS name. New name shall be reflected

Session Settings Not Listed in Citrix Web Interface web site.

In previous post , I mentioned on what need to be done by users in case the publsihed applications did not successfully launched in seamless mode. However, in some cases, users might not be able to see the option. This post will help to solve it. Issues : Session Settings preference is not listed in Citrix Web Interface web site. This is due to the option is not enabled. It can be checked at Citrix Web Interface Management Console. Troubleshooting   Launch Citrix Web Interface Management Console . Browse to Citrix Web Interface > XenApp Web Sites . You will see lists of created Sites.  Right click at the required farm URL.  Choose S e ssion Preference  This window will appeared. Browse to Remote Connnection > Display . You will see the option " Allow users to customize window size " is unchecked . Resolution : Check the option " Allow users to customize window size ", and press OK  Get users to refresh the Web

Microsoft Assessment and Planning (MAP) Toolkit - Extract Report (3/4)

As mentioned in  the first post , this KB series is about Microsoft Assessment and Planning (MAP) Toolkit. There are 4 main steps : Install MAP Toolkit and its basic configuration Collect inventory Data  Extract Report Extract Advanced Report Once inventory data collected, we can generate reports. From the inventory data collected earlier, we can use options in the toolkit to generate the report. For this example, we re going to discover Windows 10 Readiness This KB is about  how to generate report from collected inventory data. At Overview page, select the targeted scenario category. In this example, it is Desktop . At this page, select specific scenario that we after. In this example, it is Windows 10 Readiness.     It is possible to customize assessment properties. The properties will set the threshold of the assessment, such as, threshold for minimum CPU speed, acceptable free disk, as well as minimum assigned RAM. To do so, select Customize assessment pr