The WEBSERVICE function returns data from a web service hosted on the internet. The WEBSERVICE function is only available in Excel 2013 and later for Windows.
A web service uses a protocol like HTTP to retrieve data in a machine-readable format like XML or JSON. For example, a formula...Read more
In this example, the goal is to split the text strings in column B into an array of values. In a problem like this, we need to identify the delimiter, which is the character (or characters), that separate each value we...Read more
The FILTERXML function can parse XML using XPath expressions. XML is a special text format designed to transport data, with features that allow it to be easily parsed and...Read more
The Excel FILTERXML function returns specific data from XML text using a specified XPath expression.
XML is a text format for storing and transporting data. It is not dependent on any particular hardware or software. XML is extensible and is designed to transport data, as opposed...Read more
The new dynamic array formulas in Excel 365 make it much easier to solve certain tricky problems with formulas.
In this example, the goal is to generate a list of random 6-character codes. The...Read more
In the example shown, the goal is to add row numbers in column B only when there is a value in column C. The formula in B5 is:
=IF(ISBLANK(C5),"",COUNTA($C$5:C5))
The IF function first checks if cell C5...Read more
The COMBINA function returns the number of combinations for a given number of items. A combination is a group of items where order does not matter. There are two kinds of combinations:
The Excel PERMUTATIONA function returns the number of permutations (combinations where order is significant) for a given number of items. The PERMUTATIONA function allows repetitions. To calculate the number of permutations without repetitions, use the...Read more
Note: FILTER is a new dynamic array function in Excel 365. In other versions of Excel, there are alternatives, but they are more complex...Read more
The BINOM.DIST function returns the individual term binomial distribution probability. You can use BINOM.DIST to calculate probabilities that an event will occur a certain number of times in a given number of trials. BINOM.DIST returns probability as a decimal number between 0 and 1.
...Read more