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

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, s...

Microsoft Assessment and Planning (MAP) Toolkit - Collect Inventory Data (2/4)

As mentioned in  previous 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 Before we could generate a report, we need to collect inventory data. There are a few options, such as Windows computers, Linux computers, computers on VMware, Active Devices and users, etc. For this example, we re going to discover Windows Computers within a specific IP ranges. This KB is about  how to collect inventory data. At Overviews section, select Perform an inventory For this testing, let’s select Microsoft computers, and select Next For this testing, we will discover devices via IP range. Select scan an IP address range, and select Next Specify range if IPs, and select Next To discover and connect to the machines, we need to provide user account(s) that have permission to do so. Select ...

Microsoft Assessment and Planning (MAP) Toolkit - Overview

Microsoft created a  toolkit called Microsoft Assessment and Planning Toolkit that helps IT to discover current infrastructure for variety of migration projects.  This tool kit covers below scenarios : Windows computers Linux/UNIX computers VMware computers Active Directory and Users Exchange Servers Endpoint Protection Server Lync Server Softwre ID (SWID) tags SQL Server SQL Server with Database Details Microsoft Azure Platform Migration Oracle Windows Volume Licensing Client Access Tracking for Windows Server 2012 or Later Client Access Tracking for SQL Server 2012 or later Client Access Tracking for Configuration Manager Client Access Tracking for SharePoint Server 2016 Client Access Tracking for Remote Desktop Services … and IT Admins can use below methods to discover the machines. Use Active Directory Domain Service (AD DS) Use Windows networking protocols Use System Center Configuration Manager (SCCM) Scan an IP Address range Manually enter...