How to Count Unique Data in Excel
Requirement: Count Unique data in Excel using UNIQUE and COUNTIF functions Have a list which consists of number of data with duplicates values, Add on Unique formula for colors to….
Category: MS Excel
Employee progress in Excel sheet using IF Function
Requirement: Employee Progress Increasing or not using IF function in Excel sheet Create a Excel sheet, Provide three columns, Employee name, Employee Work Progress and Yes/ No. Calculating Work Progress….
Transport PDF Data into Excel
Requirement: Transferring PDF Data into Excel Sheet Instead of copying the pdf file directly into excel, Follow the below steps. Step 1:Create a PDF which contain a table in it…..
Power Automate create calendar events from excel
Requirement: create calendar events from excel in Power Automate. An Excel called Events, where events are stored, so create an event on Calendar in Outlook from Excel. Steps for power automate….
Power Automate get events into excel
Requirement: Export events in calendar into Excel Online using Power Automate. Create a MS flow that will export all the events from the calendar in outlook to Excel Online. In the….
Power automate list rows present in a table filter query contains
Requirement: Power Automate list rows present in a table filter query contains operator. The contains operator checks whether the collection or array of items contains a specific item or not. And if….
Display Excel sheet with format cells in power apps and when an item is updated in Excel sheet
Requirement: Display Excel sheet in Power apps. When the user change the color in excel sheet it automatically change the color in power apps. Create an Excel sheet before adding….
Rename file with date using Power Automate
Requirement: Rename a file with date format using MS flow In SharePoint document library an excel file called Employee.xlsx. Now to rename the file to Personsheet with the current date….
Create a Power automate flow, If the cell is empty in Microsoft Excel
Requirement: If the cell is empty in MS Excel then create a Power Automate flow Take the product excel file and check the cell is empty or not. If empty….