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

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.

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 […]

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.