## COUNTIF by cells background color in Excel

COUNTIF is an extremely useful function in Microsoft Excel. We use this function to get the count based on some conditions. Here in this article, we have created a user-defined

## Calculate Ratio in Excel

In this article, we have explained how to calculate the RATIO between two number in Excel. We have used the Excel formula as well as the User defined function in

## Shell Function in VBA

Shell Function in VBA can run executable program and returns a Variant (Double) representing the program's task ID if successful otherwise, it returns zero. Syntax Shell(pathname, [ windowstyle ]) pathname:

## RandBetweenText Formula in Excel

In this article, we have created a user defined function RandBetweenText in Excel. This function returns random text from the selected range. You can use this function to distribute the

## UDF to get the frequency of specific word in a Paragraph

I. Introduction Data analysis - a critical aspect of modern business and organizations - provides valuable insights into various datasets, allowing informed decisions to be made. While Microsoft Excel boasts

## Shell Function in VBA with Example

Shell function in VBA is very useful. If you want to start a program or open a executable file then you can use shell function in VBA . In this