SpellNumber Pakistani Rupees Function is a ready-to-use Excel function created with VBA code to change given numbers to words in Pakistani Rupees. In simple terms, it converts a numeric value of PKR to words along with paisa. Excel doesn’t have any inbuilt function to display the numeric value in words. Microsoft provides a VBA code […]
SpellNumber Bangladeshi Taka Function In Excel
SpellNumber Bangladeshi Taka Function is a ready-to-use Excel function created with VBA code to change given numbers to words in Bangladeshi Taka. In other words, it converts a numeric value of BDT to words along with poysha.
2 Ways To Display Weekday For A Date In Excel
You can use the Text Function as well as Format Cell option to display weekday for a date in excel. Using Text Function display with formula and format cell option is done without any formula.
Create Dynamic Hyperlink In Excel – 3 Easy Steps
Dynamic Hyperlink helps you create hyperlinks to navigate to different worksheets within a workbook. Learn how to create a dynamic link in just 3 easy steps. Simple hyperlinks are static. A hyperlink that changes based on the selection or any action by the user is called a dynamic hyperlink. This function is helpful when you […]
How To Use COUNTIF Function To Compare Two Dataset?
You can COUNTIF to Compare two dataset with frequent repetition of items which counts the number of cells in the selected dataset which meets the given criteria.