Converting Numbers to Roman Numerals
How to Convert Numbers to Roman Numerals using the function in Excel. Converting numbers to Roman numerals instead of typing manually use the function
Author: Rishan Solutions
Translate Text with functions in Excel
Requirement: Translating Text with the functions using the language code For Translating Text from one language to other using google translate in excel Do the same Process for remaining cells…..
Formatting Email ID’s to copy into Outlook from Excel
Requirement: Format cells to combine and copy into outlook using Excel Instead of selecting one by one email id to copy and paste in outlook, use COUNTIF formula as Textjoin….
Summing all of Criteria Sales in Excel
Requirement: Sum all of Criteria sales in excel sheet Sum- Sums cells that meet a criteria, Range- range to apply criteria to, Criteria- criteria to apply. It Sums the Sales….
Pull Language, Currency code, and Flag from value Country in Excel
Requirement: Pull the Data type values in excel Language, code, flag values from Country value Create Table, Select Data tab then click on Data types , select Country Column and….
Conditional Checkbox in Google sheet
Requirement: Formatting each completed task using conditional checkbox in Google sheet Create a google sheet, Click on Format tab, Select Conditional formatting, Then add the cell by selecting them, now….
How to Filter data in Table in Array
Requirement: Filter data in Table using Array in Excel To Filter data from one table to another, which had a collection of strings to get filtered, as the Name enter….
In Excel how to Sort data in Array
Requirement: Sort Data in Array Sorting collection of string in array using the sort function in excel list. By using the above formula Sales column Order were changed to Descending….
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….
Calculated default values in Power apps
Requirement: Adding the total value using calculated default values in fields Create a blank canvas app, add label to the screen. Now add 3 Text input controls. Add one more….