How to compare two tables for ex. Demand and Supply sheets using Excel Copilot and highlight the difference with Skill type, Primary Skill, Grade and Location being the common columns?

Valliappan, Kamala (Cognizant) 0 Reputation points
2024-05-16T08:24:08.23+00:00

We have a demand sheet of resource requirements and a supply sheet of available profiles, we need to find the deficit for each skill family, Primary Skill, grade and location wise.

for ex.

From Demand Sheet

MS Azure

Azure Security Center 

                           Manager 

                                  Bangalore , the demand is 2 

From Supply Sheet

MS Azure

    Azure Security Center 

                              Manager 

                                  Bangalore , the supply is 1 

The output expected is

Skill type Primary Skill Grade Location

MS Azure Azure Security Center Manager Bangalore

Demand Supply Deficit

2 1 1

Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365: Microsoft 365 Copilot refers collectively to Copilot experiences within Microsoft 365 applications.Development: The process of researching, productizing, and refining new or existing technologies.
67 questions
0 comments No comments
{count} votes